Konstantin Knizhnik wrote: > I wonder if Postgres community is interested in supporting time travel > queries in PostgreSQL (something like AS OF queries in Oracle: > https://docs.oracle.com/cd/B14117_01/appdev.101/b10795/adfns_fl.htm). > As far as I know something similar is now developed for MariaDB.
I think that would be a good thing to have that could make the DBA's work easier - all the requests to restore a table to the state from an hour ago. > I failed to support AS OF clause (as in Oracle) because of shift-reduce > conflicts with aliases, > so I have to introduce new ASOF keyword. May be yacc experts can propose > how to solve this conflict without introducing new keyword... I think it would be highly desirable to have AS OF, because that's the way the SQL standard has it. Yours, Laurenz Albe
