array_agg
Returns an array created from the input x elements.
Examples:
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT array_agg(column1) AS value FROM tbl;
-- value '[1, 5, 9]'
Supported Signatures
function array_agg($1) returns array<$1>
🔗 Official Documentation
avg
Returns the average (arithmetic mean) of all input values.
Examples:
CREATE TABLE tbl AS VALUES (1), (5), (9);
SELECT avg(tbl.column1) AS value FROM tbl; -- value '5.0'
Supported Signatures
function avg(double) returns double
function avg(decimal(p, s)) returns decimal(p, s)
function avg(real) returns real
🔗 Official Documentation
count
Returns the number of input rows.
Examples:
CREATE TABLE tbl AS VALUES (1), (5), (9);
SELECT count(tbl.column1) AS value FROM tbl; -- value '3'
Supported Signatures
function count() returns bigint
function count($1) returns bigint
🔗 Official Documentation
max
Returns the maximum value of all input values.
Examples:
CREATE TABLE tbl AS VALUES (1), (5), (9);
SELECT max(tbl.column1) AS value FROM tbl; -- value '9'
Supported Signatures
function max($1, ...) returns $1
🔗 Official Documentation
min
Returns the minimum value of all input values.
Examples:
CREATE TABLE tbl AS VALUES (1), (5), (9);
SELECT min(tbl.column1) AS value FROM tbl; -- value '1'
Supported Signatures
function min($1, ...) returns $1
🔗 Official Documentation
stddev
This is an alias for stddev_samp().
Supported Signatures
function stddev(bigint) returns double
function stddev(double) returns double
🔗 Official Documentation
stddev_pop
Returns the population standard deviation of all input values.
Examples:
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT stddev_pop(column1) as value from tbl;
-- value '3.265986323710904'
Supported Signatures
function stddev_pop(bigint) returns double
function stddev_pop(double) returns double
🔗 Official Documentation
stddev_samp
Returns the sample standard deviation of all input values.
Examples:
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT stddev_samp(column1) as value from tbl;
-- value '4.0'
Supported Signatures
function stddev_samp(bigint) returns double
function stddev_samp(double) returns double
🔗 Official Documentation
sum
Returns the sum of all input values.
Examples:
CREATE TABLE tbl AS VALUES (1), (5), (9);
SELECT sum(tbl.column1) AS value FROM tbl; -- value '15'
Supported Signatures
function sum(bigint) returns bigint
function sum(double) returns double
function sum(decimal(p, s)) returns decimal(38, s)
function sum(real) returns real
🔗 Official Documentation
