public inbox for [email protected]
help / color / mirror / Atom feedFrom: 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:25:26 +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">either it is hard to understand.</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">I will rephrase one part to show how it is easy to understand from my side:</div><div xmlns="http://www.w3.org/1999/xhtml">>ALL</div><div xmlns="http://www.w3.org/1999/xhtml">> The result is <span>“<span>false</span>”</span> if any false result is found.</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">The result of ALL is "false" even if *at least one* row yield false</div><div xmlns="http://www.w3.org/1999/xhtml">(we can use 'some' word here, but it is not such clear as *at least one*)</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">This sentence is easyly can be compared to:</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">>The result of <code>ALL</code> is <span>“<span>true</span>”</span> if all rows yield true</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">We can notice difference with first statement so can understand when result is different:</div><div xmlns="http://www.w3.org/1999/xhtml">(I got next picture in my mind in this case:)</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml"> all true -> true</div><div xmlns="http://www.w3.org/1999/xhtml"> at least one false -> false</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">Thus if other parts of DOC would be constructed in same manner, it would be cool</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">PS. When DOC not just document behavior but also allow eaisly detect difference when/why behavior of a command is changed.</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">Thank you.</div><div><br /></div><div><br /></div><div>12.10.2018, 00:20, "David G. Johnston" <[email protected]>:</div><blockquote type="cite">On Thursday, October 11, 2018, Bruce Momjian <<a href="mailto:[email protected]">[email protected]</a>> 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?<br />
</blockquote><div><br /></div><div>+1</div><div><br /></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