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
Дата:
От: Goboxe
Дата:
Сообщение: PostgreSQL on Windows x64
FAQ