summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian2018-11-02 12:54:33 +0000
committerBruce Momjian2018-11-02 12:54:33 +0000
commit273166af8f73670a3c7efdfb9d45893d5e011dba (patch)
treef2dd9adc98cff0191ae7dbed53d5c5e68134bd16
parentb0fa768c61b329b72e882b7923eccb249c26d74c (diff)
doc: use simpler language for NULL return from ANY/ALL
Previously the combination of "does not return" and "any row" caused ambiguity. Reported-by: KES <kes-kes@yandex.ru> Discussion: https://postgr.es/m/153701242703.22334.1476830122267077397@wrigleys.postgresql.org Reviewed-by: David G. Johnston Backpatch-through: 9.3
-rw-r--r--doc/src/sgml/func.sgml8
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 5c1a4da403b..31b855cbeec 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -13733,7 +13733,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
The result is <quote>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,
+ The result is NULL if no comparison with a subquery row returns true,
and it returns NULL for at least one row.
</para>
@@ -13759,7 +13759,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
The result of <token>ALL</token> is <quote>true</> if all rows yield true
(including the case where the subquery returns no rows).
The result is <quote>false</> if any false result is found.
- The result is NULL if the comparison does not return false for any row,
+ The result is NULL if no comparison with a subquery row returns false,
and it returns NULL for at least one row.
</para>
@@ -13789,8 +13789,8 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
case where the subquery returns no rows).
The result is <quote>false</> if the comparison returns false for any
subquery row.
- The result is NULL if the comparison does not return false for any
- subquery row, and it returns NULL for at least one row.
+ The result is NULL if no comparison with a subquery row returns false,
+ and it returns NULL for at least one row.
</para>
<para>