Temporal PostgreSQL Development Documentation

Jump to bottom

Piiit edited this page Dec 22, 2015 · 4 revisions

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"):

Special Cases for Data Types