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 1n5U0p-0006B1-Ox
	for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Jan 2022 14:45:07 +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 1n5U0o-0008RA-DY
	for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Jan 2022 14:45:06 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vik@postgresfriends.org>)
	id 1n5U0o-0008R0-40
	for pgsql-hackers@lists.postgresql.org; Thu, 06 Jan 2022 14:45:06 +0000
Received: from relay3-d.mail.gandi.net ([217.70.183.195])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vik@postgresfriends.org>)
	id 1n5U0l-0004az-Hd
	for pgsql-hackers@lists.postgresql.org; Thu, 06 Jan 2022 14:45:05 +0000
Received: (Authenticated sender: vik@postgresfriends.org)
	by relay3-d.mail.gandi.net (Postfix) with ESMTPSA id 8BAC960006;
	Thu,  6 Jan 2022 14:44:59 +0000 (UTC)
Subject: Re: SQL:2011 application time
To: Corey Huinker <corey.huinker@gmail.com>,
 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: Paul A Jungwirth <pj@illuminatedcomputing.com>,
 Jaime Casanova <jcasanov@systemguards.com.ec>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: 
 <CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail.gmail.com>
 <CA+renyWrT-srf+CiJPA4Uoyx=tmeaCimP_qkJX7w7qSFa8M5uQ@mail.gmail.com>
 <CA+renyW_hn-vuFdW2Atkjrj7E1D13ZEAnuoK9U6YD0p+f2eBAA@mail.gmail.com>
 <20210904195556.GA10553@ahch-to>
 <CA+renyXcWp9vsRkyZcSGZXfXhE5Mw2bSc2451QEMuAmDfZCpUw@mail.gmail.com>
 <20210911015017.GA8837@ahch-to>
 <CA+renyXZbr3c=UXzCdfihZMPhc2x6asZLfoeMjWRvDo+J2cTVQ@mail.gmail.com>
 <CADkLM=d-Qaq0wJNjV5K1jN9+CSNY1B9uXodAnM8dxwaDFxVCfQ@mail.gmail.com>
 <CA+renyXTJ_mACO=_pZ7q06qaGy3KsG60Q66HXypCGzSxM_qRkA@mail.gmail.com>
 <CADkLM=ekdXZceMyggb6Lqj2447VfiS-Bw22Gdgd5tBotfKmi6A@mail.gmail.com>
 <CA+renyUMKg4-MyVbAi8Kj12Srd9BkU5Gt3FdbGdNr-ezHpL6cw@mail.gmail.com>
 <5650d77a-1d73-fd8d-4410-8e97dbeff572@illuminatedcomputing.com>
 <CA+renyWqpNdsi9OaPmXheeQL72adi_iz36VgVsqyyGpQ20FDAg@mail.gmail.com>
 <21964319-46e5-3e47-217b-6ac4169bdf13@enterprisedb.com>
 <CADkLM=e7MwRH02ZS6FBZD2-t4LnH-3swyzr9JF_jZrGGzBh7NA@mail.gmail.com>
From: Vik Fearing <vik@postgresfriends.org>
Message-ID: <846b2f26-b4ff-e463-7aff-102f2683a111@postgresfriends.org>
Date: Thu, 6 Jan 2022 15:44:58 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.14.0
MIME-Version: 1.0
In-Reply-To: 
 <CADkLM=e7MwRH02ZS6FBZD2-t4LnH-3swyzr9JF_jZrGGzBh7NA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
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>
Archived-At: 
 <https://www.postgresql.org/message-id/846b2f26-b4ff-e463-7aff-102f2683a111%40postgresfriends.org>
Precedence: bulk

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