Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: doc: clarify recursion internal behavior - Mailing list pgsql-committers

From Peter Eisentraut
Subject Re: pgsql: doc: clarify recursion internal behavior
Date
Msg-id f88a4e74-8cb2-0f0f-622f-6bcff0c17ec4@enterprisedb.com
Whole thread Raw
In response to pgsql: doc: clarify recursion internal behavior  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pgsql: doc: clarify recursion internal behavior  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-committers
Tree view 
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.

pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Choose FK name correctly during partition attachment
Next
From: David Rowley
Date:
Subject: pgsql: Temporarily make MemoryContextContains return false