MIME-Version: 1.0
References: <b11fa573-38fa-ba57-96a9-e4dd9ce3fb76@2ndquadrant.com>
 <CALAY4q_voAROyjHL0fidvfY7=GGERjqSf0r=uGwrJ-T_9-VBKg@mail.gmail.com>
 <9550e917-c370-36a3-277f-2f25bfc1b497@2ndquadrant.com>
 <CALAY4q88-1P1CWCJKEGHy1S3azG5g8cP_z_sEh+cd0G14YfmgA@mail.gmail.com>
 <1c0f2169-f949-f5c5-9069-b6d0d7e110a7@pgmasters.net>
 <CALAY4q9B=D2EBEVMj6RG5tQPVw-rYw8mvKjDLYF8Bxzjr7APng@mail.gmail.com>
 <CAHHrWDP2txk9FQGqTj39iubHE=eTnoLPqVsBxdDJ-1FS9xZAaQ@mail.gmail.com>
 <CALAY4q9=RTfMu=O9=2Ovzx+iVhU+a4M5ZzxmQ2bvod77dKAg3g@mail.gmail.com>
 <00B5FD97-A568-4270-B0CF-59BA7DEEBFEA@lenstra.fr>
 <CALAY4q8ko8kpY-cm84XNNEnBdSqWUr1K5ZRmWLJy8aXG_Thrjw@mail.gmail.com>
 <20200929054427.GC7117@paquier.xyz>
 <CALAY4q-nAvQ0x3uZV=bQhZjnRHpBTuzzvzFQ263QOCzNcq3S=w@mail.gmail.com>
 <CALAY4q_LCeyMj2KPq2aA5f3L-fPF-kP_w1nuwjZJkrop-o_w=Q@mail.gmail.com>
 <CAN-V+g_ZpK7cbx7szKV8Ma6sNNGy4d34sGh5FMy14h68F8gjBQ@mail.gmail.com>
 <CALAY4q-JMDqW5=LH6f70WhiO1+tP2NhGbWv_fjPtOt=KezchUQ@mail.gmail.com>
 <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>
In-Reply-To: 
 <CALAY4q_YgDZSSHsyDAv2gY73GyWjt5V+DNUha3gL13dk9EepOw@mail.gmail.com>
From: Simon Riggs <simon.riggs@enterprisedb.com>
Date: Thu, 14 Jan 2021 21:22:26 +0000
Message-ID: 
 <CANbhV-HXDvOZL5xfHBh3KpXffpLwOwf5GRO405RP8e6DtK1rvQ@mail.gmail.com>
Subject: Re: WIP: System Versioned Temporal Table
To: Surafel Temesgen <surafel3000@gmail.com>
Cc: Ryan Lambert <ryan@rustprooflabs.com>,
 Masahiko Sawada <sawada.mshk@gmail.com>,
	Michael Paquier <michael@paquier.xyz>,
 =?UTF-8?Q?R=C3=A9mi_Lapeyre?= <remi.lapeyre@lenstra.fr>,
	Eli Marmor <eli@netmask.it>, David Steele <david@pgmasters.net>,
	Vik Fearing <vik.fearing@2ndquadrant.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
 Georgios <gkokolatos@protonmail.com>
Content-Type: text/plain; charset="UTF-8"
Precedence: bulk

On Thu, Jan 14, 2021 at 5:46 PM Surafel Temesgen <surafel3000@gmail.com> wrote:

> On Fri, Jan 8, 2021 at 7:50 PM Ryan Lambert <ryan@rustprooflabs.com> wrote:
>>
>> I prefer to have them hidden by default.  This was mentioned up-thread with no decision, it seems the standard is ambiguous.  MS SQL appears to have flip-flopped on this decision [1].

I think the default should be like this:

SELECT * FROM foo FOR SYSTEM_TIME AS OF ...
should NOT include the Start and End timestamp columns
because this acts like a normal query just with a different snapshot timestamp

SELECT * FROM foo FOR SYSTEM_TIME BETWEEN x AND y
SHOULD include the Start and End timestamp columns
since this form of query can include multiple row versions for the
same row, so it makes sense to see the validity times

-- 
Simon Riggs                http://www.EnterpriseDB.com/