Fungsi pengumpulan khusus PostgreSQL¶

ArrayAgg¶

class ArrayAgg(expression, distinct=False, filter=None, **extra)[sumber]¶

Mengembalikan daftar nilai, termasuk null, disambungkan kedalam larik.

distinct¶

New in Django 2.0.

An optional boolean argument that determines if array values will be distinct. Defaults to False.

BitAnd¶

class BitAnd(expression, filter=None, **extra)[sumber]¶

Mengembalikan sebuah int dari bitwise AND dari semua nilai-nilai masukan bukan-null, atau None jika semua nilai-nilai adalah null.

BitOr¶

class BitOr(expression, filter=None, **extra)[sumber]¶

Mengembalikan sebuah int dari bitwise OR dari semua nilai-nilai masukan bukan-null, atau None jika semua nilai-nilai adalah null.

BoolAnd¶

class BoolAnd(expression, filter=None, **extra)[sumber]¶

Mengembalikan True, jika semua nilai-nilai masukan adalah true, None jika semua nilai-nilai adalah null jika tidak ada nilai, jika tidak False.

BoolOr¶

class BoolOr(expression, filter=None, **extra)[sumber]¶

Mengembalikan True, jika setidaknya satu nilai masukan adalah true, None jika semua nilai-nilai adalah null atau, j jika tidak ada nilai, jika tidak False.

JSONBAgg¶

class JSONBAgg(expressions, filter=None, **extra)[sumber]¶

New in Django 1.11.

Returns the input values as a JSON array. Requires PostgreSQL ≥ 9.5.

StringAgg¶

class StringAgg(expression, delimiter, distinct=False, filter=None)[sumber]¶

Mengembalikan nilai-nilai masukan digabungkan kedalam string, dipisah berdasarkan string delimiter

delimiter¶

Diwajibkan argumen. Butuh berupa sebuah string.

distinct¶

New in Django 1.11.

An optional boolean argument that determines if concatenated values will be distinct. Defaults to False.

y dan x¶

The arguments y and x for all these functions can be the name of a field or an expression returning a numeric data. Both are required.

Corr¶

class Corr(y, x, filter=None)[sumber]¶

Returns the correlation coefficient as a float, or None if there aren't any matching rows.

CovarPop¶

class CovarPop(y, x, sample=False, filter=None)[sumber]¶

Returns the population covariance as a float, or None if there aren't any matching rows.

Mempunyai satu argumen pilihan:

sample¶

By default CovarPop returns the general population covariance. However, if sample=True, the return value will be the sample population covariance.

RegrAvgX¶

class RegrAvgX(y, x, filter=None)[sumber]¶

Returns the average of the independent variable (sum(x)/N) as a float, or None if there aren't any matching rows.

RegrAvgY¶

class RegrAvgY(y, x, filter=None)[sumber]¶

Returns the average of the dependent variable (sum(y)/N) as a float, or None if there aren't any matching rows.

RegrCount¶

class RegrCount(y, x, filter=None)[sumber]¶

Returns an int of the number of input rows in which both expressions are not null.

RegrIntercept¶

class RegrIntercept(y, x, filter=None)[sumber]¶

Returns the y-intercept of the least-squares-fit linear equation determined by the (x, y) pairs as a float, or None if there aren't any matching rows.

RegrR2¶

class RegrR2(y, x, filter=None)[sumber]¶

Returns the square of the correlation coefficient as a float, or None if there aren't any matching rows.

RegrSlope¶

class RegrSlope(y, x, filter=None)[sumber]¶

Returns the slope of the least-squares-fit linear equation determined by the (x, y) pairs as a float, or None if there aren't any matching rows.

RegrSXX¶

class RegrSXX(y, x, filter=None)[sumber]¶

Returns sum(x^2) - sum(x)^2/N ("sum of squares" of the independent variable) as a float, or None if there aren't any matching rows.

RegrSXY¶

class RegrSXY(y, x, filter=None)[sumber]¶

Returns sum(x*y) - sum(x) * sum(y)/N ("sum of products" of independent times dependent variable) as a float, or None if there aren't any matching rows.

RegrSYY¶

class RegrSYY(y, x, filter=None)[sumber]¶

Returns sum(y^2) - sum(y)^2/N ("sum of squares" of the dependent variable) as a float, or None if there aren't any matching rows.