The following sections describe functions, operators, expressions and methods that operate on either one-dimensional (1-D), multidimensional (n-D), or both ARRAY data types. These functions allow you to perform arithmetic, relational, and aggregate operations on an array in its entirety or on a subset of the elements composing an array.
For information on creating one-dimensional and multidimensional arrays, see CREATE TYPE (ARRAY Form).
- ARRAY Element Reference
- ARRAY_Constructor_Expression
- ARRAY Scope Reference
- ARRAY_AGG
- UNNEST
- CARDINALITY
- ARRAY_CONCATENATION_OPERATOR
- ARRAY_CONCATENATION_FUNCTION
- ARRAY_COMPARISON_FUNCTION
- ARRAY_ARITHMETIC_FUNCTION
- ARRAY_SUM
- ARRAY_AVG
- ARRAY_MAX
- ARRAY_MIN
- ARRAY_COUNT_DISTINCT
- ARRAY_GET
- ARRAY_COMPARE
- ARRAY_UPDATE
- ARRAY_UPDATE_STRIDE
- OEXISTS
- OCOUNT
- OLIMIT
- OFIRST
- OLAST
- OPRIOR
- ONEXT
- OEXTEND
- OTRIM
- ODELETE