Re: "EXECUTE ... into var" doesn't set FOUND: bug or feature?

Поиск
Список
Период
Сортировка
От Louis-David Mitterrand
Тема Re: "EXECUTE ... into var" doesn't set FOUND: bug or feature?
Дата
Msg-id 20100916141524.GA12956@apartia.fr
обсуждение исходный текст
Ответ на Re: "EXECUTE ... into var" doesn't set FOUND: bug or feature?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: "EXECUTE ... into var" doesn't set FOUND: bug or feature?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
On Thu, Sep 16, 2010 at 10:12:57AM -0400, Tom Lane wrote:
> Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org> writes:
> > I noticed that in a pl/pgsql function FOUND is not set after an
> >     EXECUTE ... into var;
> > Bug or feature?
>
> It's behaving as documented:
> http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
>
> Adding EXECUTE to the list of statements that change FOUND would have a
> rather large risk of breaking existing plpgsql functions, IMO.

but is really surprising and non-intuitive, given that 'return query
execute' does.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "EXECUTE ... into var" doesn't set FOUND: bug or feature?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: "EXECUTE ... into var" doesn't set FOUND: bug or feature?