Skip to main content

​
array_agg

Returns an array created from the input x elements. Examples:
examples.sql
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:
examples.sql
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:
examples.sql
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:
examples.sql
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:
examples.sql
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:
examples.sql
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:
examples.sql
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:
examples.sql
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
⌘I