Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gIctI-0005OA-5p for pgsql-committers@arkaria.postgresql.org; Fri, 02 Nov 2018 17:05:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gIctE-0001cL-I0 for pgsql-committers@arkaria.postgresql.org; Fri, 02 Nov 2018 17:05:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gIctE-0001cE-AB for pgsql-committers@lists.postgresql.org; Fri, 02 Nov 2018 17:05:44 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gIctB-0001lS-B2 for pgsql-committers@lists.postgresql.org; Fri, 02 Nov 2018 17:05:42 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1gIct8-0005eZ-Oo; Fri, 02 Nov 2018 13:05:38 -0400 Date: Fri, 2 Nov 2018 13:05:38 -0400 From: Bruce Momjian To: Tom Lane Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: doc: use simpler language for NULL return from ANY/ALL Message-ID: <20181102170538.GA4855@momjian.us> References: <17406.1541168421@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <17406.1541168421@sss.pgh.pa.us> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Nov 2, 2018 at 10:20:21AM -0400, Tom Lane wrote: > Bruce Momjian writes: > > doc: use simpler language for NULL return from ANY/ALL > > Previously the combination of "does not return" and "any row" caused > > ambiguity. > > IMO this is not an improvement. It's turned something that read > reasonably well into something that sounds like it was written by > a not very good speaker of English. In particular, the lack of > grammatical matching between the two parts of the sentence is now > quite confusing: > > The result is NULL if no comparison with a subquery row returns true, > and it returns NULL for at least one row. > > The antecedent of "it" was clear before, and is not now, at least to me. > > Maybe you could replace that clause with "..., and at least one comparison > returns NULL." Agreed, done. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +