From af025eed536d3842d085ed9e4f9107eb976575cc Mon Sep 17 00:00:00 2001
From: Robert Haas
Date: Fri, 8 Apr 2016 13:44:50 -0400
Subject: Add combine functions for various floating-point aggregates.
This allows parallel aggregation to use them. It may seem surprising
that we use float8_combine for both float4_accum and float8_accum
transition functions, but that's because those functions differ only
in the type of the non-transition-state argument.
Haribabu Kommi, reviewed by David Rowley and Tomas Vondra
---
doc/src/sgml/func.sgml | 40 ++++++++++++++++++++--------------------
1 file changed, 20 insertions(+), 20 deletions(-)
(limited to 'doc/src/sgml')
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 396eaa5d550..88145c5b808 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -12743,7 +12743,7 @@ NULL baz(3 rows)
double precision for a floating-point argument,
otherwise the same as the argument data type
- All types apart from floating-point types
+ Yes
the average (arithmetic mean) of all input values
@@ -13001,7 +13001,7 @@ NULL baz(3 rows)
bigint arguments, otherwise the same as the
argument data type
- All types apart from floating-point types
+ Yes
sum of expression across all input values
@@ -13153,7 +13153,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision
- No
+ Yes
correlation coefficient
@@ -13174,7 +13174,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision
- No
+ Yes
population covariance
@@ -13195,7 +13195,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision
- No
+ Yes
sample covariance
@@ -13212,7 +13212,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision
- No
+ Yes
average of the independent variable
(sum(X)/N)
@@ -13230,7 +13230,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision
- No
+ Yes
average of the dependent variable
(sum(Y)/N)
@@ -13248,7 +13248,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
bigint
- No
+ Yes
number of input rows in which both expressions are nonnull
@@ -13268,7 +13268,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision
- No
+ Yes
y-intercept of the least-squares-fit linear equation
determined by the (X,
double precision
- No
+ Yes
square of the correlation coefficient
@@ -13308,7 +13308,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision
- No
+ Yes
slope of the least-squares-fit linear equation determined
by the (X,
Y) pairs
@@ -13327,7 +13327,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision
- No
+ Yes
sum(X^2) - sum(X)^2/
double precision
- No
+ Yes
sum(X*Y) - sum(
double precision
- No
+ Yes
sum(Y^2) - sum(Y)^2/double precision for floating-point arguments,
otherwise numeric
- All types apart from floating-point types
+ Yes
historical alias for stddev_samp
@@ -13423,7 +13423,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision for floating-point arguments,
otherwise numeric
- All types apart from floating-point types
+ Yes
population standard deviation of the input values
@@ -13447,7 +13447,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision for floating-point arguments,
otherwise numeric
- All types apart from floating-point types
+ Yes
sample standard deviation of the input values
@@ -13467,7 +13467,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision for floating-point arguments,
otherwise numeric
- All types apart from floating-point types
+ Yes
historical alias for var_samp
@@ -13491,7 +13491,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision for floating-point arguments,
otherwise numeric
- All types apart from floating-point types
+ Yes
population variance of the input values (square of the population standard deviation)
@@ -13515,7 +13515,7 @@ SELECT xmlagg(x) FROM (SELECT x FROM test ORDER BY y DESC) AS tab;
double precision for floating-point arguments,
otherwise numeric
- All types apart from floating-point types
+ Yes
sample variance of the input values (square of the sample standard deviation)
--
cgit v1.2.3