array_concat
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>
array_length
function array_length(array<$1>) returns bigint
array_reverse
function array_reverse(array<$1>) returns array<$1>
array_to_string
function array_to_string(array<$1>, string) returns string function array_to_string(array<$1>, string, string) returns string
generate_array
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)
generate_date_array
function generate_date_array(date, date) returns array[date] function generate_date_array(date, date, interval) returns array[date]
generate_timestamp_array
function generate_timestamp_array $1, $2($1, $2, interval) returns array<timestamp> where $1 in (timestamp, string) and $2 in (timestamp, string)