| From: | Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
|---|---|
| To: | Surafel Temesgen <surafel3000(at)gmail(dot)com> |
| Cc: | Ryan Lambert <ryan(at)rustprooflabs(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Rémi Lapeyre <remi(dot)lapeyre(at)lenstra(dot)fr>, Eli Marmor <eli(at)netmask(dot)it>, David Steele <david(at)pgmasters(dot)net>, Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Georgios <gkokolatos(at)protonmail(dot)com> |
| Subject: | Re: WIP: System Versioned Temporal Table |
| Date: | 2021-01-15 17:01:57 |
| Message-ID: | CANbhV-G33om-YEALmhB-CNNw5fnfLAzQZu+MT55oJbwm=tpe+g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Jan 15, 2021 at 4:56 PM Surafel Temesgen <surafel3000(at)gmail(dot)com> wrote:
>
>
>
> On Fri, Jan 15, 2021 at 12:22 AM Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> wrote:
>>
>> 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
>>
>
> One disadvantage of returning system time columns is it
> breaks upward compatibility. if an existing application wants to
> switch to system versioning it will break.
There are no existing applications, so for PostgreSQL, it wouldn't be an issue.
If you mean compatibility with other databases, that might be an
argument to do what others have done. What have other databases done
for SELECT * ?
--
Simon Riggs http://www.EnterpriseDB.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Borodin | 2021-01-15 17:05:49 | Re: Yet another fast GiST build |
| Previous Message | Surafel Temesgen | 2021-01-15 16:56:42 | Re: WIP: System Versioned Temporal Table |