Feedback-ID: i131946ab:Fastmail
Message-ID: <ee0a326f-d358-16f2-8dbb-a5172f982142@enterprisedb.com>
Date: Wed, 24 Aug 2022 19:58:04 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
 Gecko/20100101 Thunderbird/91.12.0
Subject: Re: [PATCH] doc/queries.sgml: add missing comma
Content-Language: en-US
To: Bruce Momjian <bruce@momjian.us>,
 "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Drew DeVault <sir@cmpwn.com>,
 Pg Docs <pgsql-docs@lists.postgresql.org>
References: <20211018091720.31299-1-sir@cmpwn.com>
 <2007662.1634679184@sss.pgh.pa.us>
 <CAKFQuwbp31e9bx38nfN16z0Vrqig7D=dh8WCN+aMBbxMaDw8Dg@mail.gmail.com>
 <Yv6AqJuvnP3HelUP@momjian.us>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: <Yv6AqJuvnP3HelUP@momjian.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/ee0a326f-d358-16f2-8dbb-a5172f982142%40enterprisedb.com>
Precedence: bulk

On 18.08.22 20:10, Bruce Momjian wrote:
>> Thus:
>> Strictly speaking, this process is iteration, but <literal>RECURSIVE</literal>
>> is the terminology chosen by the SQL standards committee."
>>
>> Because the above sounds just fine, I'd argue that if one does leave "not
>> recursion" it should be set off by a comma.
> I went with new wording, which should make this even clearer;  patch
> attached.

I think this whole note is a bit misleading, like the SQL people don't 
know what recursion is.  The point is that the query is defined 
recursively.  The evaluation process is iterative.  Those two are not 
contradictions.