postgres.aggregates.RegrAvgY
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class RegrAvgY(y, x) [source] Returns the average of the dependent variable (sum(y)/N)

2025-01-10 15:47:30
postgres.aggregates.RegrSXX
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class RegrSXX(y, x) [source] Returns sum(x^2) - sum(x)^2/N (“sum of squares”

2025-01-10 15:47:30
postgres.aggregates.BoolOr
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class BoolOr(expression, **extra) [source] Returns True if at least one input

2025-01-10 15:47:30
postgres.aggregates.BoolAnd
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class BoolAnd(expression, **extra) [source] Returns True, if all input values

2025-01-10 15:47:30
postgres.aggregates.StringAgg.delimiter
  • References/Python/Django/API/PostgreSQL specific aggregation functions

delimiter Required argument. Needs to be a string.

2025-01-10 15:47:30
postgres.aggregates.StringAgg
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class StringAgg(expression, delimiter) [source] Returns the input values concatenated into

2025-01-10 15:47:30
postgres.aggregates.RegrIntercept
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class RegrIntercept(y, x) [source] Returns the y-intercept of the least-squares-fit linear

2025-01-10 15:47:30
postgres.aggregates.CovarPop.sample
  • References/Python/Django/API/PostgreSQL specific aggregation functions

sample By default CovarPop returns the general population covariance. However, if sample=True, the

2025-01-10 15:47:30
postgres.aggregates.Corr
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class Corr(y, x) [source] Returns the correlation coefficient as a float, or

2025-01-10 15:47:30
postgres.aggregates.RegrSlope
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class RegrSlope(y, x) [source] Returns the slope of the least-squares-fit linear equation

2025-01-10 15:47:30