Re: AS OF queries - Mailing list pgsql-hackers

From legrand legrand
Subject Re: AS OF queries
Date
Msg-id 1514328216747-0.post@n3.nabble.com
Whole thread Raw
In response to Re: AS OF queries  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: AS OF queries  (David Fetter <david@fetter.org>)
List pgsql-hackers
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>';

?

Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


pgsql-hackers by date:

Previous
From: Martin Marques
Date:
Subject: Re: Does PostgreSQL check database integrity at startup?
Next
From: Alban Hertroys
Date:
Subject: Re: Deadlock between concurrent index builds on different tables