Re: WIP: System Versioned Temporal Table
| От | Surafel Temesgen |
|---|---|
| Тема | Re: WIP: System Versioned Temporal Table |
| Дата | |
| Msg-id | CALAY4q8Pp699qv-pJZc4toS-e2NzRJKrvaX-xqG1aqj2Q+Ww-w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: WIP: System Versioned Temporal Table (Simon Riggs <simon.riggs@enterprisedb.com>) |
| Ответы |
Re: WIP: System Versioned Temporal Table
|
| Список | pgsql-hackers |
On Fri, Jan 15, 2021 at 12:22 AM Simon Riggs <simon.riggs@enterprisedb.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.
regards
Surafel
В списке pgsql-hackers по дате отправления: