range_agg() — PostgreSQL aggregate aggregate function
range_agg(): combine aggregate input into a multirange. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
Function Category: Aggregate Functions
range_intersect_agg() — PostgreSQL aggregate aggregate function
range_intersect_agg(): range aggregate by intersecting. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
regr_avgx() — PostgreSQL aggregate aggregate function
regr_avgx(): average of the independent variable (sum(X)/N). PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
regr_avgy() — PostgreSQL aggregate aggregate function
regr_avgy(): average of the dependent variable (sum(Y)/N). PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
regr_count() — PostgreSQL aggregate aggregate function
regr_count(): number of input rows in which both expressions are not null. PostgreSQL aggregate functions — signature, volatility, version applicability…
regr_intercept() — PostgreSQL aggregate aggregate function
regr_intercept(): y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs. PostgreSQL aggregate functions — signature, volatility, version…
regr_r2() — PostgreSQL aggregate aggregate function
regr_r2(): square of the correlation coefficient. PostgreSQL aggregate functions — signature, volatility, version applicability and an illustrative example.
regr_slope() — PostgreSQL aggregate aggregate function
regr_slope(): slope of the least-squares-fit linear equation determined by the (X, Y) pairs. PostgreSQL aggregate functions — signature, volatility, version…
regr_sxx() — PostgreSQL aggregate aggregate function
regr_sxx(): sum of squares of the independent variable (sum(X^2) - sum(X)^2/N). PostgreSQL aggregate functions — signature, volatility, version applicability and…
regr_sxy() — PostgreSQL aggregate aggregate function
regr_sxy(): sum of products of independent times dependent variable (sum(X*Y) - sum(X) * sum(Y)/N). PostgreSQL aggregate functions — signature, volatility,…