4 ms·
Check out https://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables or https://github.com/scalegenius/pg_bitemporal https://github
by phonon 6y ago
Check out https://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables or https://github.com/scalegenius/pg_bitemporal https://github.com/scalegenius/pg_bitemporal
- jacques_chester 6y agoI'm familiar with these and they are useful, but I would greatly prefer mainline support using the SQL standard. A mainline implementation is far more likely to lead to optimisations being made to the query planner, indices, disk formats etc.
- phonon 6y agoI am in vehement agreement!
- gurjeet 6y agoYou may be pleased to know that someone is actively working on this. There was a presentation [1] by the author Paul A. Jungwirth at this year's PGCon last week. [1]: https://www.pgcon.org/events/pgcon_2020/schedule/session/100-progress-adding-sql2011-valid-time-to-postgres/ https://www.pgcon.org/events/pgcon_2020/schedule/session/100...