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

The following bug has been logged online:

Bug reference:      3320
Logged by:          Jan Szumiec
Email address:      jan.szumie@infiniteloop.eu
PostgreSQL version: 8.2.4
Operating system:   Windows XP
Description:        Error when using INSERT...RETURNING as a subquery
Details:

Having:

CREATE TABLE efforts
(
  id serial NOT NULL,
  effort integer
)
WITHOUT OIDS;

CREATE TABLE items
(
  id serial NOT NULL,
  "type" character varying(255),
  created_at timestamp without time zone,
  subject character varying(255),
  body text,
  effort integer,
  CONSTRAINT items_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;

executing the following query:

UPDATE items SET (type, post_id) = (INSERT INTO efforts (effort) VALUES
(667) RETURNING 'Item', id) WHERE id = 1937

produces this error:

ERROR: syntax error at or near "INTO"
SQL state:42601
Character:44