Re: SQL:2011 application time - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: SQL:2011 application time
Date
Msg-id 846b2f26-b4ff-e463-7aff-102f2683a111@postgresfriends.org
Whole thread Raw
In response to Re: SQL:2011 application time  (Corey Huinker <corey.huinker@gmail.com>)
Responses Re: SQL:2011 application time
List pgsql-hackers
On 1/5/22 11:03 PM, Corey Huinker wrote:
> 
> There was similar work being done for system periods, which are a bit
> simpler but require a side (history) table to be created.

This is false.  SYSTEM_TIME periods do not need any kind of history.
This was one of the problems I had with Surafel's attempt because it was
confusing the period with SYSTEM VERSIONING.  Versioning needs the
period but the inverse is not true.
-- 
Vik Fearing



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: sqlsmith: ERROR: XX000: bogus varno: 2
Next
From: Julien Rouhaud
Date:
Subject: Re: ICU for global collation