Re: How to handle things that change over time?

On 13/09/2019 17:19, Paul Jungwirth wrote:
> The SQL:2011 standard also has temporal primary keys, foreign keys,
> SELECTs, and UPDATE/DELETEs, and we're working on adding those too.

And here is a full implementation of all that:
https://github.com/xocolatl/periods/

It is packaged in both the deb and rpm repositories for PGDG.