What type is required to capture the RETURNING from anUpdate?

Поиск
Список
Период
Сортировка
От rox
Тема What type is required to capture the RETURNING from anUpdate?
Дата
Msg-id 91bf7f4a0830f5d8cf431e5641d0c3e4@mail.webfaction.com
обсуждение исходный текст
Ответы Re: What type is required to capture the RETURNING from anUpdate?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Within 8.4, If I have an update like the following :


   EXECUTE $c$
    UPDATE field_seasons dr
        SET season_id = ds.season_id, field_id = ds.field_id
    FROM data_set ds
    WHERE ds.data_set_id = dr.data_set_id
    AND ds.season_id = _season_id
    RETURNING field_seasons_id
    $c$
   INTO _id_array;


in a pgsql FUNCTION... What is the type on the variable that can accept
the list of id's?

integer[] doesn't work.  It gives back "22P02 array value must start
with "{" or dimension information."


Roxanne

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: PQisBusy() always busy
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What type is required to capture the RETURNING from anUpdate?