<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">>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" <david(dot)g(dot)johnston(at)gmail(dot)com>:</div><blockquote xmlns="http://www.w3.org/1999/xhtml" type="cite">On Thursday, October 11, 2018, Bruce Momjian <<a href="mailto:bruce(at)momjian(dot)us">bruce(at)momjian(dot)us</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?</blockquote><div> </div><div>+1</div><div> </div><div>David J. </div></blockquote>