From f72aad5678b5d9bf570a51a9899b4e950ce9f828 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 21 Feb 2000 01:20:41 +0000 Subject: [PATCH] Update discussion of aggregate syntax to mention ALL. --- doc/src/sgml/syntax.sgml | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index 08f7955df9..332464429c 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -711,6 +711,7 @@ sqrt(emp.salary) aggregate_name (expression) + aggregate_name (ALL expression) aggregate_name (DISTINCT expression) aggregate_name ( * ) @@ -723,7 +724,8 @@ sqrt(emp.salary) The first form of aggregate expression invokes the aggregate across all input rows for which the given expression yields a non-null value. - The second form invokes the aggregate for all distinct non-null values + The second form is the same as the first, since ALL is the default. + The third form invokes the aggregate for all distinct non-null values of the expression found in the input rows. The last form invokes the aggregate once for each input row regardless of null or non-null values; since no particular input value is specified, it is generally only useful -- 2.40.0