Vik Fearing-4 wrote > On 05/01/2020 11:16, Surafel Temesgen wrote: >> >> >> On Fri, Jan 3, 2020 at 4:22 PM Vik Fearing >> <
> vik.fearing@ > <mailto: > vik.fearing@ > >> wrote: >> > > [...] > > You only test FROM-TO and with a really wide interval. There are no > tests for AS OF and no tests for BETWEEN-AND. > > > 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 . Regards PAscal -- Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
