plpgsql execute vs. SELECT ... INTO

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема plpgsql execute vs. SELECT ... INTO
Дата
Msg-id 4CD489FF.1000908@dunslane.net
обсуждение исходный текст
Ответы Re: plpgsql execute vs. SELECT ... INTO  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
(Prompted by a puzzled user on IRC)

Ten years ago, nearly, we made this commit 
<https://github.com/postgres/postgres/commit/8a2cdd77ad5c0a4f8902ea86d0377336e076abcb> 
(see what a good thing it is we carefully got all the history 
transferred to git?)

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-plpgsqlsemantics   as it was doing for the last few weeks/months.  This keeps our options   open for making it do
theright plpgsql-ish thing in future without   creating a backwards compatibility problem.  There is no loss of
functionalitysince 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?

cheers

andrew



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "Make" versus effective stack limit in regression tests
Следующее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql execute vs. SELECT ... INTO