can't get UPDATE ... RETURNING ... INTO ... to compile successfully

From: Dale <harris_da(at)yahoo(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Date: 2008-08-18 07:14:15
Message-ID: 5296267e-f2e7-4395-9239-75d17d34d51b@a3g2000prm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I've got some code which postgres 8.3.3 won't accept. Postgres
doesn't like the INTO clause on RETURNING INTO and I've tried
following the documentation.

UPDATE "EntityRelation" SET "Status" = inStatus, "Modified" =
Session_TimeStamp(), "ModifiedBy" = UserID() WHERE ("RelationID" =
inRelationID) AND ("EntityID" = inEnityID) AND IsEqual(inRelatedID,
"RelatedID") RETURNING "Default" INTO oldDefault;

Does anyone have any ideas if the INTO clause actually works at all
for an UPDATE statement?

Regards,
Dale.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2008-08-18 08:00:57 Re: Postres.exe Processes Hang
Previous Message Goboxe 2008-08-18 06:48:10 PostgreSQL on Windows x64