array_append
any_compatible
to the end of the input array.
array_cat
array_dims
array_distinct
array_flatten
array_length
array_length ( array )
array_length ( array int )
array
. int
must be 1.
array_lower
array
. (This is always 1 or null.)
array_max
array_min
array_ndims
array
.
array_position
any_compatible
element in array
.
array_positions
any_compatible
element in array
.
array_prepend
any_compatible
to the beginning of the input array.
array_remove
any_compatible
element removed. Multidimensional arrays are also supported.
array_replace
current_element
replaced with new_element
. Multidimensional arrays are also supported. When the array is multidimensional, the element must be an array of one less dimension. Recursively replacing the base element of a multidimensional array is not supported.
array_sort
array_sum
array_to_string
and array_join
delimiter_string
separates the array’s elements in the resulting string, and the optional null_string
represents NULL
elements in the array. array_join
can also be used instead of array_to_string
.
array_transform
array_expression
is evaluated against the transform_expression
. element_alias
is an alias that represents an array element.
transform_expression
does not support referencing columns. For example, if you have a table:
array_upper
array
. int
must be 1
. (This will return the same value as array_length
.)
cardinality
array
or 0 if the array is empty.
string_to_array
delimiter_string
separates the string
’s elements to create the resulting array, and the optional null_string
represents NULL
elements in the array.
trim_array
unnest
array @> array -> boolean
array <@ array -> boolean
array || anycompatible → array
array_append
.
array || array → array
array_cat
.
anycompatible || array → array
array_prepend
.