Re: Writeable CTEs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Writeable CTEs
Date
Msg-id 12968.1262716828@sss.pgh.pa.us
Whole thread Raw
In response to Writeable CTEs  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
Responses Re: Writeable CTEs  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
List pgsql-hackers
Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi> writes:
> => with t as (delete from foo returning *)
> -> insert into bar
> -> select * from t;
> INSERT 0 2

> It correctly reports 2 affected rows (one deleted and one inserted), but 
> is this the answer we want?

No.  The returned tag should consider only the top-level operation,
not what happened inside any CTEs.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Proposal: XML helper functions
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial