Re: [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY
Дата
Msg-id 603c8f070901100518j6bd99bdq80caa0dde7fce994@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Ответы Re: [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
> 2009/1/10 Tom Lane <tgl@sss.pgh.pa.us>:
>> Bruce Momjian <bruce@momjian.us> writes:
>>> Uh, is this ready to be applied?
>>
>> I don't think any consensus has been reached on changing this behavior.
>
> I  thing, so this is bug - RETURN QUERY has to supply FOR SELECT LOOP
> RETURN NEXT pattern.
>
> My first patch expected so RETURN QUERY is final statement, so I don't
> solve FOUND variable, but Heikki changed this behave.
>
> Without correct FOUND behave we can't to use RETURN QUERY for following pattern
>
> RETURN QUERY some;
> IF FOUND THEN RETURN; END IF;
> RETURN QUERY some_other;
> RETURN;

+1.  I can't imagine it's good for this to be randomly inconsistent.

...Robert


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

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: WIP: Automatic view update rules
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Synch Rep v5