Aggregate Functions

any_value

Supported Signatures

function any_value($1) returns $1

🔗 Official Documentation

array_agg

Supported Signatures

function array_agg($1) returns array<$1>

🔗 Official Documentation

array_avg

Supported Signatures

function array_avg $1(array<$1>) returns double
	where $1 in (int, bigint, float, double)

🔗 Official Documentation

array_concat_agg

Supported Signatures

function array_concat_agg(array<$1>) returns array<$1>

🔗 Official Documentation

avg

Supported Signatures

function avg $1($1) returns $1
	where $1 in (double, interval)
function avg(bigint) returns double

🔗 Official Documentation

bit_and

Supported Signatures

function bit_and(bigint) returns bigint

🔗 Official Documentation

bit_or

Supported Signatures

function bit_or(bigint) returns bigint

🔗 Official Documentation

bit_xor

Supported Signatures

function bit_xor(bigint) returns bigint

🔗 Official Documentation

corr

Supported Signatures

function corr(float64, float64) returns float64

🔗 Official Documentation

count

Supported Signatures

function count($1) returns bigint

🔗 Official Documentation

countif

Supported Signatures

function countif(bool) returns bigint

🔗 Official Documentation

covar_pop

Supported Signatures

function covar_pop(float64, float64) returns float64

🔗 Official Documentation

covar_samp

Supported Signatures

function covar_samp(float64, float64) returns float64

🔗 Official Documentation

logical_and

Supported Signatures

function logical_and(bool) returns bool

🔗 Official Documentation

logical_or

Supported Signatures

function logical_or(bool) returns bool

🔗 Official Documentation

max

Supported Signatures

function max($1) returns $1

🔗 Official Documentation

max_by

Supported Signatures

function max_by($1, $2) returns $1

🔗 Official Documentation

min

Supported Signatures

function min($1) returns $1

🔗 Official Documentation

min_by

Supported Signatures

function min_by($1, $2) returns $1

🔗 Official Documentation

stddev_pop

Supported Signatures

function stddev_pop(float64) returns float64

🔗 Official Documentation

stddev_samp

Supported Signatures

function stddev_samp(float64) returns float64

🔗 Official Documentation

string_agg

Supported Signatures

function string_agg $1($1) returns $1
	where $1 in (string, bytes)
function string_agg $1($1, $1) returns $1
	where $1 in (string, bytes)

🔗 Official Documentation

sum

Supported Signatures

function sum($1) returns $1

🔗 Official Documentation

var_pop

Supported Signatures

function var_pop(float64) returns float64

🔗 Official Documentation

var_samp

Supported Signatures

function var_samp(float64) returns float64

🔗 Official Documentation