We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Progress adding SQL:2011 valid time to Postgres

7
 Cite
 Share
 Related Material
 Download
 Purchase
No logo availablePGCon - PostgreSQL Conference for Users and Developers
 Jungwirth, Paul A.

Formal Metadata

Title
Progress adding SQL:2011 valid time to Postgres
Title of Series
Number of Parts
32
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
I have a patch in progress to add SQL:2011 valid time support to Postgres, so that you can more easily record a history of things that change over time. It lets you define temporal primary and foreign keys and issue temporal UPDATE and DELETE commands. Although the SQL:2011 standard introduces a new concept called PERIODs, I've based the Postgres features on our own built-in ranges---and plan to support PERIODs too (hopefully before I get to PGCon).