Array Functions

SELECT ARRAY_CONCAT([1, 2], [3, 4], [5, 6]) as count_to_six; -- value '[1,2,3,4,5,6]'

function array_concat(array<$1>, ...) returns array<$1>

function array_length(array<$1>) returns bigint

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

function array_to_string(array<$1>, string) returns string
function array_to_string(array<$1>, string, string) returns string

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

function generate_date_array(date, date) returns array[date]
function generate_date_array(date, date, interval) returns array[date]

function generate_timestamp_array $1, $2($1, $2, interval) returns array<timestamp>
	where $1 in (timestamp, string)
	and $2 in (timestamp, string)