Skip to content

Commit b5acaa8

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 877b005 commit b5acaa8

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
@@ -15049,7 +15049,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1504915049
The result is <quote>false</> if the comparison returns false for every
1505015050
subquery row (including the case where the subquery returns no
1505115051
rows).
15052-
The result is NULL if the comparison does not return true for any row,
15052+
The result is NULL if no comparison with a subquery row returns true,
1505315053
and it returns NULL for at least one row.
1505415054
</para>
1505515055

@@ -15075,7 +15075,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1507515075
The result of <token>ALL</token> is <quote>true</> if all rows yield true
1507615076
(including the case where the subquery returns no rows).
1507715077
The result is <quote>false</> if any false result is found.
15078-
The result is NULL if the comparison does not return false for any row,
15078+
The result is NULL if no comparison with a subquery row returns false,
1507915079
and it returns NULL for at least one row.
1508015080
</para>
1508115081

@@ -15105,8 +15105,8 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1510515105
case where the subquery returns no rows).
1510615106
The result is <quote>false</> if the comparison returns false for any
1510715107
subquery row.
15108-
The result is NULL if the comparison does not return false for any
15109-
subquery row, and it returns NULL for at least one row.
15108+
The result is NULL if no comparison with a subquery row returns false,
15109+
and it returns NULL for at least one row.
1511015110
</para>
1511115111

1511215112
<para>

0 commit comments

Comments
 (0)