can't get UPDATE ... RETURNING ... INTO ... to compile successfully
От
Dale
Тема
can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Дата
Msg-id
5296267e-f2e7-4395-9239-75d17d34d51b@a3g2000prm.googlegroups.com
Список
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.
В списке pgsql-general по дате отправления
От: Lew
Дата: