Re: plpgsql execute vs. SELECT ... INTO

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql execute vs. SELECT ... INTO
Дата
Msg-id 3915.1288997646@sss.pgh.pa.us
обсуждение исходный текст
Ответ на plpgsql execute vs. SELECT ... INTO  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: plpgsql execute vs. SELECT ... INTO  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> The comment on the commit says:

>     EXECUTE of a SELECT ... INTO now draws a 'not implemented' error,
>     rather than executing the INTO clause with non-plpgsql semantics
>     as it was doing for the last few weeks/months.  This keeps our options
>     open for making it do the right plpgsql-ish thing in future without
>     creating a backwards compatibility problem.  There is no loss of
>     functionality since people can get the same behavior with CREATE TABLE AS.

> Do we really still need to keep out options open on this after all that 
> time?

I think it's still a good idea that it won't do something that is very
much different from what a non-EXECUTE'd SELECT INTO will do.

I forget, is there a HINT there suggesting CREATE TABLE AS?  Maybe we
should add one if not.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: plpgsql execute vs. SELECT ... INTO
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: plpgsql execute vs. SELECT ... INTO