Re: Updated INSERT/UPDATE RETURNING

"Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com> writes:
> On 8/5/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> BTW, it occurs to me to wonder whether we've picked a good choice
>> of syntax. I don't remember where the suggestion to use "RETURNING"
>> came from (did we borrow it from another DBMS?).

> Oracle. DB2 uses something similar to SELECT * FROM (UPDATE tbl SET ... );

Oh, okay.

>> The simplest alternative that comes to mind is to use RETURNS instead
>> I don't have a strong feeling either way, but now is the time to
>> decide.

> I don't care either way, RETURNS is fine I guess.

Well, if the syntax is compatible with Oracle as-is, that's probably
a sufficient reason to stick with it. It's not like we haven't got
any other non-spec reserved words ...

regards, tom lane