Re: WIP: System Versioned Temporal Table

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP: System Versioned Temporal Table
Date: 2021-01-15 19:26:05
Message-ID: 1610738765994-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2021-01-15 19:50:43 Re: [patch] [doc] Further note required activity aspect of automatic checkpoint and archving
Previous Message Andres Freund 2021-01-15 19:23:30 Re: O(n^2) system calls in RemoveOldXlogFiles()