Re: AS OF queries

On Tue, Dec 26, 2017 at 03:43:36PM -0700, legrand legrand wrote:
> would actual syntax
>
> WITH old_foo AS
> (select * from foo as of '<some time>')
> select * from foo except select * from old_foo;
>
> work in replacement for
>
> select * from foo except select * from foo as old_foo as of '<some time>';
>
> ?

If there has to be a WITH, or (roughly) equivalently, a sub-select for
each relation, the queries get very hairy very quickly. It would
nevertheless be better for the people who need the feature to have it
this way than not to have it at all.

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate