On Saturday 02 February 2008 4:12 pm, Jonah H. Harris wrote: > On Feb 2, 2008 6:22 PM, chrisj <[EMAIL PROTECTED]> wrote: > > I know I could do this easily with a stored proc, > > but it seems like an obvious use of the returning clause > > > > Am I missing some syntax error > > Nope, you're not missing anything. When I initially wrote this for > Postgres, it didn't support all cases; including the one you're > running into. It's not extremely difficult to extend, but as there > are so few people asking for this functionality, no one has found it > important enough to warrant extension. Perhaps I'll get to it for > 8.4.
Would this be a variation of this item from the TODO: * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php -- Adrian Klaver [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate