On Thu, Oct 8, 2009 at 6:52 AM, Robert Haas <robertmh...@gmail.com> wrote: > up to the main query. For what may turn out to be pretty common uses > cases like WITH tuples AS (DELETE FROM big_table_1 RETURNING ...) > INSERT INTO big_table_2 ... this is going to suck pretty bad. I
Is the above form: with x as (delete .. returning *) insert into y select * from x going to be allowed? I was informed on irc that it wasn't...it would have to be written as: insert into y with x as (delete .. returning *) select * from x IOW, will WITH be able to terminate in update/insert/delete and not just select? merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
