Re: insert ... delete ... returning ... ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: insert ... delete ... returning ... ?
Date
Msg-id 8368.1203893092@sss.pgh.pa.us
Whole thread Raw
In response to Re: insert ... delete ... returning ... ?  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: insert ... delete ... returning ... ?  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: insert ... delete ... returning ... ?  (Mark Mielke <mark@mark.mielke.cc>)
List pgsql-hackers
"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> Not stupid, it doesn't work :)  This was a limitation of the original
> design based on (IIRC) executor-related issues.

There are definitional issues not only implementation ones; in
particular, in subquery-like cases it's entirely unclear how many times
the DML operation will or should get evaluated.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: insert ... delete ... returning ... ?
Next
From: "Jonah H. Harris"
Date:
Subject: Re: insert ... delete ... returning ... ?