Andrew Dunstan wrote: > >>> I need to use query like: > >>> select (insert into test (a) values (x) returning b),c from anytable > >>> where condition > >>> but it say > >>> ERROR: syntax error at or near "into" > >>> > >>> Is this a bug? > >>> > >> No, it's a known limitation. > >> > > > > Is there a TODO item for this? I don't see one, do you? > > > > > 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
Yes, but the TODO item talks about its use in the FROM clause, while the failed query is using it in the target list. Updated TODO with new URL is: * Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause or target list http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php http://archives.postgresql.org/pgsql-hackers/2008-06/msg00124.php -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
