Content-Length: 285188 | pFad | http://github.com/postgres/postgres/commit/f499dabbd51da787aae359f62d336d439dd440ed

46 doc: use simpler language for NULL return from ANY/ALL · postgres/postgres@f499dab · GitHub
Skip to content

Commit f499dab

Browse files
committed
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
1 parent 82dd1c2 commit f499dab

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

doc/src/sgml/func.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -12848,7 +12848,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1284812848
The result is <quote>false</> if the comparison returns false for every
1284912849
subquery row (including the case where the subquery returns no
1285012850
rows).
12851-
The result is NULL if the comparison does not return true for any row,
12851+
The result is NULL if no comparison with a subquery row returns true,
1285212852
and it returns NULL for at least one row.
1285312853
</para>
1285412854

@@ -12874,7 +12874,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1287412874
The result of <token>ALL</token> is <quote>true</> if all rows yield true
1287512875
(including the case where the subquery returns no rows).
1287612876
The result is <quote>false</> if any false result is found.
12877-
The result is NULL if the comparison does not return false for any row,
12877+
The result is NULL if no comparison with a subquery row returns false,
1287812878
and it returns NULL for at least one row.
1287912879
</para>
1288012880

@@ -12904,8 +12904,8 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1290412904
case where the subquery returns no rows).
1290512905
The result is <quote>false</> if the comparison returns false for any
1290612906
subquery row.
12907-
The result is NULL if the comparison does not return false for any
12908-
subquery row, and it returns NULL for at least one row.
12907+
The result is NULL if no comparison with a subquery row returns false,
12908+
and it returns NULL for at least one row.
1290912909
</para>
1291012910

1291112911
<para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgres/postgres/commit/f499dabbd51da787aae359f62d336d439dd440ed

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy