Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1l0Ujh-0007xp-I4
	for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Jan 2021 19:26:17 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1l0Ujg-00065R-DY
	for pgsql-hackers@arkaria.postgresql.org; Fri, 15 Jan 2021 19:26:16 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <legrand_legrand@hotmail.com>)
	id 1l0Ujg-00065K-6l
	for pgsql-hackers@lists.postgresql.org; Fri, 15 Jan 2021 19:26:16 +0000
Received: from n3.nabble.com ([162.255.23.22])
	by makus.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <legrand_legrand@hotmail.com>)
	id 1l0UjX-0002Fe-92
	for pgsql-hackers@postgresql.org; Fri, 15 Jan 2021 19:26:15 +0000
Received: from n3.nabble.com (localhost [127.0.0.1])
	by n3.nabble.com (Postfix) with ESMTP id 0DE6123ED2C37
	for <pgsql-hackers@postgresql.org>; Fri, 15 Jan 2021 12:26:06 -0700 (MST)
Date: Fri, 15 Jan 2021 12:26:05 -0700 (MST)
From: legrand legrand <legrand_legrand@hotmail.com>
To: pgsql-hackers@postgresql.org
Message-ID: <1610738765994-0.post@n3.nabble.com>
In-Reply-To: 
 <CANbhV-G33om-YEALmhB-CNNw5fnfLAzQZu+MT55oJbwm=tpe+g@mail.gmail.com>
References: 
 <CAD21AoAUDJj_y_5fH5FLBLUDTZa579jbE5Y12SQz4nJh-RVx7A@mail.gmail.com>
 <CANbhV-EZu-SHXERZ=Bbq5g+ePi7QUX_0WgLtRsove_Jiigtaaw@mail.gmail.com>
 <CANbhV-EOTSc2EWS_LKiXKgLqnrjtaU0hf3Rzxn111nir6Pn4zA@mail.gmail.com>
 <CANbhV-ECkPhsXEtj7gYFjXCdq+3WTiHo9XkF5wQmFOj4w+YTaw@mail.gmail.com>
 <CANbhV-Fb35HMoySGMFfcxN_3i45Bb6cZODOcz8S7+Nys3Y2raA@mail.gmail.com>
 <CAN-V+g-D7bObC3m5rcm3zr8MmTVE4_OVJuEp8Qse0ZgE4PAhsw@mail.gmail.com>
 <CALAY4q_YgDZSSHsyDAv2gY73GyWjt5V+DNUha3gL13dk9EepOw@mail.gmail.com>
 <CANbhV-HXDvOZL5xfHBh3KpXffpLwOwf5GRO405RP8e6DtK1rvQ@mail.gmail.com>
 <CALAY4q8Pp699qv-pJZc4toS-e2NzRJKrvaX-xqG1aqj2Q+Ww-w@mail.gmail.com>
 <CANbhV-G33om-YEALmhB-CNNw5fnfLAzQZu+MT55oJbwm=tpe+g@mail.gmail.com>
Subject: Re: WIP: System Versioned Temporal Table
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

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