Looking Forward to Postgres 19: It's About Time Recently, a new type of question has entered the database arena: what did this data look like last Tuesday? Maybe it's the price of a product before the holiday sale kicked in, or which department an employee belonged to before that reorg nobody asked for. Short of adding an entire audit trigger system, how can we know what data looked like before and after a change at that exact date? The SQL:2011 standard formalized a proper solution over a...

Looking Forward to Postgres 19: It's About Time
Shaun Thomas
