avg(
expression
) |
smallint, int, 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 |
bit_and(
expression
) |
smallint, int, bigint, or bit |
same as argument data type |
the bitwise AND of all non-null input values, or null if none |
bit_or(
expression
) |
smallint, int, bigint, or bit |
same as argument data type |
the bitwise OR of all non-null input values, or null if none |
bool_and(
expression
) |
bool |
bool |
true if all input values are true, otherwise false |
bool_or(
expression
) |
bool |
bool |
true if at least one input value is true, otherwise false |
count(*)
|
|
bigint
|
number of input values |
count(
expression
)
|
any |
bigint
|
number of input values for which the value of
expression
is not null |
every(
expression
) |
bool |
bool |
equivalent to bool_and
|
max(
expression
)
|
any array, numeric, string, or date/time type |
same as argument type |
maximum value of
expression
across all input values |
min(
expression
)
|
any array, numeric, string, or date/time type |
same as argument type |
minimum value of
expression
across all input values |
stddev(
expression
) |
smallint, int, bigint, real, double precision, or numeric |
double precision for floating-point arguments, otherwise numeric |
sample standard deviation of the input values |
sum(
expression
)
|
smallint, int, bigint, real, double precision, numeric, or interval |
bigint for smallint or int 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, int, 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) |
