Temporal PostgreSQL Development Documentation - Piiit/tpg GitHub Wiki

We collect any kind of development related information here.

Temporal query examples:

With temporal primitives (aligner, normalizer):

  • SELECT * FROM (e NORMALIZE f USING() WITH (ts, te, ts, te)) c;
  • SELECT * FROM (e NORMALIZE f ON TRUE WITH (ts, te, ts, te)) c;
  • SELECT * FROM (e NORMALIZE f USING(a,b) WITH (ts, te, ts, te)) c;
  • SELECT * FROM (e NORMALIZE f ON a=1 AND e.b=f.b WITH (ts, te, ts, te)) c;

Temporal aggregation:

  • SELECT *, COUNT(*) FROM e GROUP BY PERIOD WITH (ts, te);

This list is not finished yet!

Future work ("a do-not-forget list"):