I am interested databases, languages, logic, and platforms. I post ideas or insights here that I think others may find useful.
I have been a PostgreSQL user for over 10 years. During that time I’ve authored Synchronized Scans for version 8.3, and Exclusion Constraints for version 9.0. I’ve also been a community participant, taking part in patch review, mailing list discussion, and community events.
Your blog mentions the new PERIOD type quite a bit yet I am having difficulty determining if it made it into the PostgreSQL 9.0 or 9.1 release. Would you be able to answer that question?
Thank you!
Cymen
Hi!
PERIOD is an extension, and it’s available here: http://pgxn.org/dist/temporal/ or https://github.com/jeff-davis/PostgreSQL-Temporal
I am also working on a feature for 9.2 called Range Types, which is like PERIOD, except available for many subtypes. For instance, PERIOD is like a range of TIMESTAMPTZ, but it’s also useful for ranges of DATEs, ranges of NUMERICs, ranges of INTEGERs, etc. Because of some type system changes and other conveniences, Range Types requires core changes and thus will (hopefully) be a part of 9.2 out-of-the-box.
Also, after Range Types is committed, I will try to make as much of it an extension as I can, so that people using 9.1 and before can benefit.