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
обсуждение исходный текст
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Lew
Дата:
Сообщение: Re: can't get UPDATE ... RETURNING ... INTO ... to compile successfully
Следующее
От: Goboxe
Дата:
Сообщение: PostgreSQL on Windows x64