avg(expression) |
smallint, integer, bigint,
real, double
precision, numeric, or
interval. |
numeric for any integer type
argument, double precision for a
floating-point argument, otherwise the same as the
argument data type |
the average (arithmetic mean) of all input
values |
|
count(*) |
|
bigint |
number of input values |
|
count(expression) |
any |
bigint |
number of input values for which the value of
expression is not
null |
|
max(expression) |
any numeric, string, or date/time type |
same as argument type |
maximum value of expression across all input
values |
|
min(expression) |
any numeric, string, or date/time type |
same as argument type |
minimum value of expression across all input
values |
|
stddev(expression) |
smallint, integer, bigint,
real, double
precision, or numeric. |
double precision for
floating-point arguments, otherwise numeric. |
sample standard deviation of the input values |
|
sum(expression) |
smallint, integer, bigint,
real, double
precision, numeric, or
interval |
bigint for smallint or integer
arguments, numeric for bigint arguments, double
precision for floating-point arguments, otherwise
the same as the argument data type |
sum of expression
across all input values |
|
variance(expression) |
smallint, integer, bigint,
real, double
precision, or numeric. |
double precision for
floating-point arguments, otherwise numeric. |
sample variance of the input values (square of the
sample standard deviation) |
|