PDXPUG: Multiranges and SQL:2011 Temporal Features

Note: This will be an online event. You must RSVP to get the link to the meeting, which will be set shortly before the meeting as we will be using Jitsi (https://jitsi.org). Jitsi can be used directly with Firefox and Chrome (with extension), or phones/tablets with the Jitsi Meet app.

Speaker: Paul Jungwirth

I'd like to present a couple patches I have in-progress for Postgres, the first to add a new type called "multiranges", and the second to add various SQL:2011 temporal database features: temporal primary & foreign keys, and temporal UPDATE and DELETE. I'll discuss what these features look like to users and also highlight some of the implementation details behind them.