Request a Demo
Home   >   mailing lists

Re: WIP: System Versioned Temporal Table - Mailing list pgsql-hackers

From legrand legrand
Subject Re: WIP: System Versioned Temporal Table
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: WIP: System Versioned Temporal Table  (Simon Riggs <[email protected]>)
List pgsql-hackers
Tree view 
Hello,

it seems that Oracle (11R2) doesn't add the Start and End timestamp columns 
and permit statement like

select * from tt
union
select * from tt
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' SECOND)
minus 
select * from tt
VERSIONS BETWEEN TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' second) and
SYSTIMESTAMP;

Regards
PAscal



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: O(n^2) system calls in RemoveOldXlogFiles()
Next
From: "David G. Johnston"
Date:
Subject: Re: [patch] [doc] Further note required activity aspect of automatic checkpoint and archving