| Function |
Description |
| ARRAY_AGG |
Aggregates a set of elements into an array. |
| ARRAY_DELETE |
Deletes an element or range of elements from an associative array. |
| ARRAY_FIRST |
Returns the smallest array index value of the array. |
| ARRAY_LAST |
Returns the largest array index value of the array. |
| ARRAY_NEXT |
Returns the next larger array index value for an array relative to the specified array index argument. |
| ARRAY_PRIOR |
Returns the next smaller array index value for an array relative to the specified array index argument. |
| CARDINALITY |
Returns a value of type BIGINT representing the number of elements of an array |
| MAX_CARDINALITY |
Returns a value of type BIGINT representing the maximum number of elements that an array can contain. |
| TRIM_ARRAY |
Returns a value with the same array type as array-variable but with the cardinality reduced by the value of numeric-expression. |
| UNNEST table function |
Returns a result table that includes a row for each element of the specified array. |
