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
