Re: SQL:2011 Valid-Time Support

On 5/8/18 11:31, Tom Lane wrote:
> Paul Howells <paul(dot)steven(dot)howells(at)gmail(dot)com> writes:
>> Has there been or is there any current effort to implement SQL:2011
>> valid-time support in Postgres?
>
> Searching the archives, I can only find "valid-time" appearing in these
> threads related to temporal query processing:
>
> https://www.postgresql.org/message-id/flat/200702100020.28893.wt%40penguintechs.org

That looks like a pre-standardization variant of the same idea.

> https://www.postgresql.org/message-id/flat/CALNdv1h7TUP24Nro53KecvWB2kwA67p%2BPByDuP6_1GeESTFgSA%40mail.gmail.com

I think those are operators that work on top of having the valid-time
available, but don't do anything about making that time available.

> Anyway, if it's in the standard, then at least in principle we're open
> to it. There'd probably be some questions about the amount of added
> complexity and whether the feature is worth supporting. I'd suggest
> trying to get some community buy-in by circulating a design document
> on -hackers before you write any code.

I think there is some interest, so it's worth proceeding like that.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services