diff options
| author | Bruce Momjian <bruce@momjian.us> | 2018-11-02 08:54:34 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2018-11-02 08:54:34 -0400 |
| commit | 8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a (patch) | |
| tree | 453ebcd458ea94bb2cebbd4922a9b922d76a77dc /doc/src | |
| parent | 6286efb5240f4ce4f1cd51bc11f49d367b7e7f62 (diff) | |
| download | postgresql-8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a.tar.gz postgresql-8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 10816f556bd..74e8cf18519 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15246,7 +15246,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2); The result is <quote>false</quote> 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> @@ -15272,7 +15272,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2); The result of <token>ALL</token> is <quote>true</quote> if all rows yield true (including the case where the subquery returns no rows). The result is <quote>false</quote> 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> @@ -15302,8 +15302,8 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2); case where the subquery returns no rows). The result is <quote>false</quote> 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> |