Re: INSERT ... RETURNING in v8.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: INSERT ... RETURNING in v8.2
Date
Msg-id 12014.1182126054@sss.pgh.pa.us
Whole thread Raw
In response to Re: INSERT ... RETURNING in v8.2  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Allison escribi�:
>> insert into table(string) values(('one'),('two'),('three')) returning
>> idx;
>>
>> I realize that this is an extension to standard SQL but it sure would
>> save me a lot.

> You are wrong -- you can do it, but it is not an extension.  It is in
> the standard.

Uh, I don't even see RETURNING as a reserved word in SQL2003.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: INSERT ... RETURNING in v8.2
Next
From: Christopher Browne
Date:
Subject: Re: VACUUM ANALYZE extremely slow