Note: For an alphabetical listing of the array functions and operators, see the listing in the navigation bar.
Most of the functions and operators listed here can use an array of any dimensionality, but four of the functions accept, or produce, only a one-dimensional array. This property is called out by the second column "1-d only?" in the tables that follow. The restricted status is indicated by "1-d" in that function's row. When the field is blank, there is no dimensionality restriction.
Functions for creating arrays from scratch
The array[] constructor, and the three functions, create an array from scratch.
The array[] value constructor is a special variadic function that creates an array value from scratch using an expression for each of the array's values. Such an expression can itself use the array[] constructor or an array literal.
Returns a one-dimensional text[] array by splitting the input text value into subvalues using the specified text value as the delimiter. Optionally, allows a specified text value to be interpreted as NULL.
Functions for reporting the geometric properties of an array
Returns TRUE if the LHS array is contained by the RHS array—that is, if every distinct value in the LHS array is found among the RHS array's distinct values.
Returns a new array whose length is defined by specifying the slice's lower and upper bound along each dimension. These specified slicing bounds must not exceed the source array's bounds. The new array has the same dimensionality as the source array and its lower bound is 1 on each axis.
Functions and operators for concatenating an array with an array or an element
These functions require that the two arrays have the same data type and compatible dimensionality.
Returns a text value computed by representing each array value, traversing these in row-major order, by its ::text typecast, using the supplied delimiter between each such representation. (The result, therefore, loses all information about the arrays geometric properties.) Optionally, represent NULL by the supplied text value.
Table function to transform an array into a SETOF anyelement
Use in the FROM clause of a SELECT statement. The simple overload accepts a single anyarray value and returns a SETOF anyelement. The exotic overload accepts a variadic list of anyarray values and returns a SETOF with many columns where each, in turn, has the output of the corresponding simple overload.
Table function to transform an array into a SETOF index values