- The result is NULL if the comparison does not return true for any row,
+ The result is NULL if no comparison with a subquery row returns true,
and it returns NULL for at least one row.
+ The result is NULL if no comparison with a subquery row returns true,
and it returns NULL for at least one row.
-The result of
ANY is “true” if the comparison returns true for any subquery row. The result is “false” 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.Similary to:
>The result of ALL is "false" even if *at least one* row yield false
+The result of ANY is "true" if at least one row yields true.
The result of ANY is "false" if all rows yield false
The result of ANY is NULL if no one row yelds true and at least one row yields NULL
When subquery return no rows the result of ANY is "false"
sentences are short, easy to spot when and how result is changed
12.10.2018, 00:20, "David G. Johnston" <david.g.johns...@gmail.com>:
On Thursday, October 11, 2018, Bruce Momjian <br...@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?+1David J.
