doc: clarify recursion internal behavior

Reported-by: Drew DeVault
Discussion: https://postgr.es/m/20211018091720.31299-1-sir@cmpwn.com

Backpatch-through: 10

diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml
index 18a9e79259fcc8dfda8d4e74a643e1ff8614c337..5366f1f7e6dcfb26bd2077a510d041ab2804d1dc 100644 (file)
--- a/doc/src/sgml/queries.sgml
+++ b/doc/src/sgml/queries.sgml
@@ -2110,9 +2110,8 @@ SELECT sum(n) FROM t;
 
   <note>
    <para>
-    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.
    </para>
   </note>