3 ms·

No support for temporal data as in SQL:2011. There were some attempts but none made it so far. See also: https://wiki.postgresql.org/images/6/64/Fosdem20150130

• dragonwriter 10y ago
  > No support for temporal data as in SQL:2011. Clearly, it doesn't have support for SQL:2011 temporal syntax, but with range types and exclusion constraints, it seems to have fairly good support for doing the things you can do with SQL:2011's temporal features. (And, having dealt with business data where multiple business [application] date ranges of relevance applied, I think that SQL:2011's "bitemporal" approach which provides special syntax for a single each system of system and application date/time range is in some respects creating an overly-specialized solution to a too-narrow subset of the temporal data problem.)