postgres.git / summary / log / commit / refs

commit    eff71cd910ad8cd1931bd78103f8d5b9fd8e634b
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Fri Nov 02 12:54:33 2018 +0000
First released in: 12.0, 9.3.25, 9.4.20, 9.5.15, 9.6.11, 10.6, 11.1

    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


 doc/src/sgml/func.sgml | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 8bf467577d1..841472d1ca3 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -14123,7 +14123,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>
 
@@ -14149,7 +14149,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>
 
@@ -14179,8 +14179,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>


[parent: d554e333e548]