On Tue, May 29, 2007 at 09:41:38AM -0400, Tom Lane wrote: > "Jan Szumiec" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
