Re: select into

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: select into
Дата
Msg-id 4198.1164384120@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: select into  (Adrian Klaver <aklaver@comcast.net>)
Список pgsql-sql
Adrian Klaver <aklaver@comcast.net> writes:
> On Thursday 23 November 2006 08:45 pm, Tom Lane wrote:
>> This should work --- in PG 8.1 or later.

> The documentation for pl/pgsql  in 8.1 and higher says different. 

> http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
> " SELECT INTO is not currently supported within EXECUTE."

That says you can't doEXECUTE 'select ... into foo ...';
which is not the same thing asEXECUTE 'select ...' into foo;
        regards, tom lane


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: select into
Следующее
От: Mulham freshcode
Дата:
Сообщение: Re: select into