2 ms·
There are two different kind of temporal queries. One is about getting the state of the db at a given time. The other is to get the state about a given time. E
by pmontra 10y ago
There are two different kind of temporal queries. One is about getting the state of the db at a given time. The other is to get the state about a given time.
Example: I got paid yesterday and the operation will be recorded only tomorrow.
The first kind of query AS OF today will never show the payment. The second one will do (assuming that behavior is appropriate for the application, better examples are possible.)
CockroachDB, SQLServer and Oracle implemented the first one. That's why they are writing about backups.
Edit: see this PostgreSQL extension for the second kind of queries http://pgxn.org/dist/temporal_tables/ http://pgxn.org/dist/temporal_tables/
- pjungwir 10y agoUnfortunately the Postgres temporal_tables extension is about the first kind not the second kind: "What did the database look like on April 1st?" not "What did this customer look like on April 1st?". From your link: > Currently, Temporal Tables Extension supports the system-period temporal tables only. Also here is the same extension on github: https://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables