Scalar functions for manipulating arrays
array_append
array_sort
ASC
or DESC
).NULLS FIRST
or NULLS LAST
).array_resize
array_cat
array_concat
array_contains
array_has
array_has_all
array_has_any
array_dims
array_distinct
array_element
array_extract
array_fill
array_repeat
instead!
flatten
array_indexof
array_intersect
array_join
array_length
array_ndims
array_prepend
array_pop_front
array_pop_back
array_position
array_positions
array_push_back
array_push_front
array_repeat
count
times.
array_remove
array_remove_n
max
elements from the array equal to the given value.
array_remove_all
array_replace
array_replace_n
max
occurrences of the specified element with another specified element.
array_replace_all
array_reverse
array_slice
array_to_string
array_union
array_except
cardinality
empty
generate_series
list_append
list_cat
list_concat
list_dims
list_distinct
list_element
list_empty
list_except
list_extract
list_has
list_has_all
list_has_any
list_indexof
list_intersect
list_join
list_length
list_ndims
list_prepend
list_pop_back
list_pop_front
list_position
list_positions
list_push_back
list_push_front
list_repeat
list_resize
list_remove
list_remove_n
list_remove_all
list_replace
list_replace_n
list_replace_all
list_reverse
list_slice
list_sort
list_to_string
list_union
make_array
array_empty
make_list
string_to_array
null_str
argument are replaced with NULL.
SELECT string_to_array('abc##def', '##')
or SELECT string_to_array('abc def', ' ', 'def')
NULL
string_to_list
trim_array
array_slice
instead!
range
SELECT range(2, 10, 3) -> [2, 5, 8]
or SELECT range(DATE '1992-09-01', DATE '1993-03-01', INTERVAL '1' MONTH);
The range start..end contains all values with start <= x < end. It is empty if start >= end.
Step can not be 0 (then the range will be nonsense.).
Note that when the required range is a number, it accepts (stop), (start, stop), and (start, stop, step) as parameters, but when the required range is a date, it must be 3 non-NULL parameters.
For example,