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.BitAnd
  • References/Python/Django/API/PostgreSQL specific aggregation functions

class BitAnd(expression, **extra) [source] Returns an int of the bitwise AND

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

class CovarPop(y, x, sample=False) [source] Returns the population covariance as a float

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

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

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

class RegrCount(y, x) [source] Returns an int of the number of input rows in

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

class RegrR2(y, x) [source] Returns the square of the correlation coefficient as a float

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

class BitOr(expression, **extra) [source] Returns an int of the bitwise OR

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

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

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

class RegrSXY(y, x) [source] Returns sum(x*y) - sum(x) * sum(y)/N (“sum of products”

2025-01-10 15:47:30