Re: pgsql: doc: clarify recursion internal behavior

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: doc: clarify recursion internal behavior
Date: 2022-09-08 11:24:14
Message-ID: f88a4e74-8cb2-0f0f-622f-6bcff0c17ec4@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On 03.09.22 03:58, Bruce Momjian wrote:
> doc: clarify recursion internal behavior

- Strictly speaking, this process is iteration not recursion, but
- <literal>RECURSIVE</literal> is the terminology chosen by the SQL
standards
- committee.
+ 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.

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message David Rowley 2022-09-08 12:29:33 pgsql: Temporarily make MemoryContextContains return false
Previous Message Alvaro Herrera 2022-09-08 11:19:58 pgsql: Choose FK name correctly during partition attachment