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) | |