Skip to content

Commit 273166a

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 b0fa768 commit 273166a

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
@@ -13733,7 +13733,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1373313733
The result is <quote>false</> if the comparison returns false for every
1373413734
subquery row (including the case where the subquery returns no
1373513735
rows).
13736-
The result is NULL if the comparison does not return true for any row,
13736+
The result is NULL if no comparison with a subquery row returns true,
1373713737
and it returns NULL for at least one row.
1373813738
</para>
1373913739

@@ -13759,7 +13759,7 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1375913759
The result of <token>ALL</token> is <quote>true</> if all rows yield true
1376013760
(including the case where the subquery returns no rows).
1376113761
The result is <quote>false</> if any false result is found.
13762-
The result is NULL if the comparison does not return false for any row,
13762+
The result is NULL if no comparison with a subquery row returns false,
1376313763
and it returns NULL for at least one row.
1376413764
</para>
1376513765

@@ -13789,8 +13789,8 @@ WHERE EXISTS (SELECT 1 FROM tab2 WHERE col2 = tab1.col2);
1378913789
case where the subquery returns no rows).
1379013790
The result is <quote>false</> if the comparison returns false for any
1379113791
subquery row.
13792-
The result is NULL if the comparison does not return false for any
13793-
subquery row, and it returns NULL for at least one row.
13792+
The result is NULL if no comparison with a subquery row returns false,
13793+
and it returns NULL for at least one row.
1379413794
</para>
1379513795

1379613796
<para>

0 commit comments

Comments
 (0)