Re: pgsql: doc: clarify recursion internal behavior

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: doc: clarify recursion internal behavior
Дата
Msg-id 3976627.1662651004@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pgsql: doc: clarify recursion internal behavior  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: pgsql: doc: clarify recursion internal behavior
Список pgsql-committers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Sep 8, 2022 at 7:24 AM Peter Eisentraut
> <peter.eisentraut@enterprisedb.com> wrote:
>> On 03.09.22 03:58, Bruce Momjian wrote:
>>> +    While <literal>RECURSIVE</literal> allows queries to be specified
>>> +    recursively, internally all queries are evaluated iteratively.

>> Is that true?  Surely there is some recursive behavior in the executor.

> I haven't read the patch, but I think the claim shown here is correct.

I'd be happier if it read "such queries" instead of "all queries".
The latter is an extremely broad claim, and you have to ignore cases
like recursive SQL functions in order to even argue it's true.

            regards, tom lane



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: pgsql: doc: clarify recursion internal behavior
Следующее
От: Peter Geoghegan
Дата:
Сообщение: pgsql: Instrument freezing in autovacuum log reports.