Re: BUG #3320: Error when using INSERT...RETURNING as a subquery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jan Szumiec" <jan(dot)szumie(at)infiniteloop(dot)eu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3320: Error when using INSERT...RETURNING as a subquery
Date: 2007-05-29 13:41:38
Message-ID: 3313.1180446098@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Jan Szumiec" <jan(dot)szumie(at)infiniteloop(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2007-05-29 14:27:24 Re: BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5
Previous Message Tom Lane 2007-05-29 13:35:00 Re: BUG #3319: Superuser can't revoke grants on a schema given by aother user