Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #3320: Error when using INSERT...RETURNING as a subquery
Date
Msg-id 3313.1180446098@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3320: Error when using INSERT...RETURNING as a subquery  ("Jan Szumiec" <jan.szumie@infiniteloop.eu>)
Responses Re: BUG #3320: Error when using INSERT...RETURNING as a subquery  (David Fetter <david@fetter.org>)
List pgsql-bugs
Tree view 
"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.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3319: Superuser can't revoke grants on a schema given by aother user
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5