Re: BUG #3320: Error when using INSERT...RETURNING as a subquery - Mailing list pgsql-bugs

From David Fetter
Subject Re: BUG #3320: Error when using INSERT...RETURNING as a subquery
Date
Msg-id 20070529165915.GA1912@fetter.org
Whole thread Raw
In response to Re: BUG #3320: Error when using INSERT...RETURNING as a subquery  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #3320: Error when using INSERT...RETURNING as a subquery  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-bugs
On Tue, May 29, 2007 at 09:41:38AM -0400, Tom Lane wrote:
> "Jan Szumiec" <jan.szumie@infiniteloop.eu> writes:
> > UPDATE items SET (type, post_id) = (INSERT INTO efforts (effort) VALUES
> > (667) RETURNING 'Item', id) WHERE id = 1937
>
> Sorry, RETURNING is only supported at the top level of a query.

What would be involved with making this possible?  What we have at the
moment is a pretty clear POLA violation because unlike the rest of the
row-returning objects (tables, views, SRFs and VALUES() clauses), only
RETURNING can't be used in a subquery.

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
Next
From: Gregory Stark
Date:
Subject: Re: BUG #3320: Error when using INSERT...RETURNING as a subquery