Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1gAiNZ-000713-PR
	for pgsql-docs@arkaria.postgresql.org; Thu, 11 Oct 2018 21:20:21 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1gAiNV-00009P-OU
	for pgsql-docs@arkaria.postgresql.org; Thu, 11 Oct 2018 21:20:17 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1gAiNV-00009F-GI
	for pgsql-docs@lists.postgresql.org; Thu, 11 Oct 2018 21:20:17 +0000
Received: from mail-qk1-x744.google.com ([2607:f8b0:4864:20::744])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1gAiNP-0008Nc-5Y
	for pgsql-docs@lists.postgresql.org; Thu, 11 Oct 2018 21:20:16 +0000
Received: by mail-qk1-x744.google.com with SMTP id g20-v6so6429185qke.9
        for <pgsql-docs@lists.postgresql.org>;
 Thu, 11 Oct 2018 14:20:10 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :cc;
        bh=LvKA9c0jRMFa20PO6VZE6wtKSQXsy+LHYy2LCPG7f+k=;
        b=oZj1Xv8iYJ+0t12mGfGjac02KEaynC1ZY12f7M+88PpYrtpfM+EZo47LZ5ie2/mX1O
         ZMBVw2mWSPITL+6xnMiBe9W4mG9nn5/bEOlqAxrnuasCTeAH2c3zLd7VZGrxynBljCpa
         Ge4Dm08Gkb9k3UkiKV+QVs06ddtCDst1cV8C4gCweTuGu2aV2GLNYX1snWbqO/P1GSKH
         ZDpO94c4Qy8g6W6LdcBSwHtWMe5PR/uLoQwoA4GwXQ7ah9FUQYLljxyK5flHLScqjTZK
         9MYEMUYA5S1tzrkl9r5X5DAlDJVDVsf8+zByPTytl7D/gbw3kjtf99lPdkT7s5e1maqc
         mZZQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:in-reply-to:references:from:date
         :message-id:subject:to:cc;
        bh=LvKA9c0jRMFa20PO6VZE6wtKSQXsy+LHYy2LCPG7f+k=;
        b=DxNRnGnzwKxbeNTN6tPX1tDGi8+DeJb0fQNS1aD0Ckjfv6vi1G92LTbKSfFguRjZOC
         YVkhkU1s0XzHWVchsS4Z22m5S6OKgg4+6IsENFAnjdQPn/lLrThDa5MpRdZnSG+4qpUk
         y89psO7kkOrwd/W+NXDcfFOsJLTUG5AzOSFoiHIZ804tKF5ZbvNlbkrseMkE3Kxhkg2E
         kRvad+HU5Guh8zCHVZnjhIYMC9R7Bgn3Xz8unSdZcCqtaT1peeIMTtJc/qMxlPcd1K6E
         VWydVTpZ/yBNC79U50AxRG+ouFtEKRUdIRyC+VDiQxpBTiqG/Q5dhFDfWMmzjBRZzGRS
         CfGg==
X-Gm-Message-State: ABuFfojbn3aJnIitL99/MHqZxIRIQEE8NAlH1P2cbtxkkOHC5kYwweCG
	knjOWGXGS6RleWhrWLdOp0H3jls94mhe7SzCoj8=
X-Google-Smtp-Source: 
 ACcGV61p0D7aZoj/XAxBAlSvzxLJWMAbQBgH0rU7isucZjkNJmYbZH+gHfsxBK+61KDzD1RsVXCss1e38Aa4Ro5ADxw=
X-Received: by 2002:a37:d86:: with SMTP id
 128-v6mr3179018qkn.11.1539292808771;
 Thu, 11 Oct 2018 14:20:08 -0700 (PDT)
MIME-Version: 1.0
Received: by 2002:a0c:b50b:0:0:0:0:0 with HTTP; Thu, 11 Oct 2018 14:20:07
 -0700 (PDT)
In-Reply-To: <20181011210934.GG7807@momjian.us>
References: <153701242703.22334.1476830122267077397@wrigleys.postgresql.org>
 <20181011210934.GG7807@momjian.us>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 11 Oct 2018 14:20:07 -0700
Message-ID: 
 <CAKFQuwYo-oahQS_8x8ax06Gs_y_P02Hjokso3XCLvpOvZip-bQ@mail.gmail.com>
Subject: Re: Ambiguous usage of 'any' in explanation
To: Bruce Momjian <bruce@momjian.us>
Cc: "kes-kes@yandex.ru" <kes-kes@yandex.ru>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000127e070577fa89b2"
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>
Precedence: bulk

--000000000000127e070577fa89b2
Content-Type: text/plain; charset="UTF-8"

On Thursday, October 11, 2018, Bruce Momjian <bruce@momjian.us> wrote:
>
>         The result is NULL if no comparison with a subquery row returns
>         false, and it returns NULL for at least one row.
>
> I can make similar adjustments in other places, and have attached a doc
> patch.  Does that help?
>

+1

David J.

--000000000000127e070577fa89b2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thursday, October 11, 2018, Bruce Momjian &lt;<a href=3D"mailto:bruce@mo=
mjian.us">bruce@momjian.us</a>&gt; wrote:<blockquote class=3D"gmail_quote" =
style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
=C2=A0 =C2=A0 =C2=A0 =C2=A0 The result is NULL if no comparison with a subq=
uery row returns<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 false, and it returns NULL for at least one row=
.<br>
<br>
I can make similar adjustments in other places, and have attached a doc<br>
patch.=C2=A0 Does that help?<br>
</blockquote><div><br></div><div>+1</div><div><br></div><div>David J.=C2=A0=
</div>

--000000000000127e070577fa89b2--