public inbox for [email protected]  

help / color / mirror / Atom feed
From: KES <[email protected]>
To: David G. Johnston <[email protected]>
To: Bruce Momjian <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Ambiguous usage of 'any' in explanation
Date: Fri, 12 Oct 2018 13:42:03 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKFQuwYo-oahQS_8x8ax06Gs_y_P02Hjokso3XCLvpOvZip-bQ@mail.gmail.com>
References: <[email protected]>
	<[email protected]>
	<CAKFQuwYo-oahQS_8x8ax06Gs_y_P02Hjokso3XCLvpOvZip-bQ@mail.gmail.com>

<div xmlns="http://www.w3.org/1999/xhtml">-   The result is NULL if the comparison does not return true for any row,<br />+   The result is NULL if no comparison with a subquery row returns true,<br />    and it returns NULL for at least one row.</div><div xmlns="http://www.w3.org/1999/xhtml">-The result of <code>ANY</code> is <span>“<span>true</span>”</span> if the comparison returns true for any subquery row. The result is <span>“<span>false</span>”</span> if the comparison returns false for every subquery row (including the case where the subquery returns no rows). The result is NULL if the comparison does not return true for any row, and it returns NULL for at least one row.</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">Similary to:</div><div xmlns="http://www.w3.org/1999/xhtml">&gt;The result of ALL is "false" even if *at least one*  row yield false</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">+The result of ANY is "true" if at least one row yields true.</div><div xmlns="http://www.w3.org/1999/xhtml">The result of ANY is "false" if all rows yield false</div><div xmlns="http://www.w3.org/1999/xhtml">The result of ANY is NULL if no one row yelds true and at least one row yields NULL</div><div xmlns="http://www.w3.org/1999/xhtml">When subquery return no rows the result of ANY is "false"</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">sentences are short, easy to spot when and how result is changed</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">12.10.2018, 00:20, "David G. Johnston" &lt;[email protected]&gt;:</div><blockquote xmlns="http://www.w3.org/1999/xhtml"; type="cite">On Thursday, October 11, 2018, Bruce Momjian &lt;<a href="mailto:[email protected]">[email protected]</a>&gt; wrote:<blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex;">         The result is NULL if no comparison with a subquery row returns<br />        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.  Does that help?</blockquote><div> </div><div>+1</div><div> </div><div>David J. </div></blockquote>

view thread (13+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Ambiguous usage of 'any' in explanation
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox