Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1oUITQ-0005pH-OF
	for pgsql-docs@arkaria.postgresql.org; Sat, 03 Sep 2022 02:01:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1oUITP-0001xW-Au
	for pgsql-docs@arkaria.postgresql.org; Sat, 03 Sep 2022 02:01:27 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1oUIQS-0008Uf-SA
	for pgsql-docs@lists.postgresql.org; Sat, 03 Sep 2022 01:58:24 +0000
Received: from momjian.us ([72.94.173.45])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1oUIQQ-0000Tz-5L
	for pgsql-docs@lists.postgresql.org; Sat, 03 Sep 2022 01:58:23 +0000
Received: from bruce by momjian.us with local (Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1oUIQK-00A9Rg-U2; Fri, 02 Sep 2022 21:58:16 -0400
Date: Fri, 2 Sep 2022 21:58:16 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
	Tom Lane <tgl@sss.pgh.pa.us>, Drew DeVault <sir@cmpwn.com>,
	Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: Re: [PATCH] doc/queries.sgml: add missing comma
Message-ID: <YxK0uKKpsCex/IsO@momjian.us>
References: <20211018091720.31299-1-sir@cmpwn.com>
 <2007662.1634679184@sss.pgh.pa.us>
 <CAKFQuwbp31e9bx38nfN16z0Vrqig7D=dh8WCN+aMBbxMaDw8Dg@mail.gmail.com>
 <Yv6AqJuvnP3HelUP@momjian.us>
 <ee0a326f-d358-16f2-8dbb-a5172f982142@enterprisedb.com>
 <Yw5UgsYGPGYsXsaW@momjian.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Yw5UgsYGPGYsXsaW@momjian.us>
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/YxK0uKKpsCex/IsO%40momjian.us>
Precedence: bulk

On Tue, Aug 30, 2022 at 02:18:42PM -0400, Bruce Momjian wrote:
> On Wed, Aug 24, 2022 at 07:58:04PM +0200, Peter Eisentraut wrote:
> > 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.
> 
> Okay, makes sense.  Here is an updated patch.

Patch applied back to PG 10.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson