regr_syy() — PostgreSQL aggregate aggregate function
regr_syy(): sum of squares of the dependent variable (sum(Y^2) - sum(Y)^2/N). PostgreSQL aggregate functions — signature, volatility, version applicability and…
Function Category: Aggregate Functions
stddev() — PostgreSQL aggregate aggregate function
stddev(): historical alias for stddev_samp. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
stddev_pop() — PostgreSQL aggregate aggregate function
stddev_pop(): population standard deviation of bigint input values. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
stddev_samp() — PostgreSQL aggregate aggregate function
stddev_samp(): sample standard deviation of bigint input values. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
string_agg() — PostgreSQL aggregate aggregate function
string_agg(): concatenate aggregate input into a string. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
sum() — PostgreSQL aggregate aggregate function
sum(): sum as numeric across all bigint input values. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative…
var_pop() — PostgreSQL aggregate aggregate function
var_pop(): population variance of bigint input values (square of the population standard deviation). PostgreSQL aggregate functions — signature, volatility, version…
var_samp() — PostgreSQL aggregate aggregate function
var_samp(): sample variance of bigint input values (square of the sample standard deviation). PostgreSQL aggregate functions — signature, volatility, version…
variance() — PostgreSQL aggregate aggregate function
variance(): historical alias for var_samp. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
xmlagg() — PostgreSQL aggregate aggregate function
xmlagg(): concatenate XML values. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.