Re: WIP: System Versioned Temporal Table
Vik Fearing <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.general |
|---|---|
| Message-ID | <[email protected]> |
On 05/01/2020 16:01, legrand legrand wrote: > >> As for the syntax, you have: >> >> >> select a from for stest0 system_time from '2000-01-01 00:00:00.00000' to >> 'infinity' ORDER BY a; >> >> >> when you should have: >> >> >> select a from stest0 for system_time from '2000-01-01 00:00:00.00000' to >> 'infinity' ORDER BY a; >> >> >> That is, the FOR should be on the other side of the table name. >> >> [...] >> >> Vik Fearing > Hello, > > I though that standard syntax was "AS OF SYSTEM TIME" > as discussed here > https://www.postgresql.org/message-id/flat/A254CDC3-D308-4822-8928-8CC584E0CC71%40elusive.cx#06c5dbffd5cfb9a20cdeec7a54dc657f > , also explaining how to parse such a syntax . No, that is incorrect. The standard syntax is: FROM tablename FOR SYSTEM_TIME AS OF '...' FROM tablename FOR SYSTEM_TIME BETWEEN '...' AND '...' FROM tablename FOR SYSTEM_TIME FROM '...' TO '...' -- Vik Fearing