Function Category: Array Functions

array_append() — PostgreSQL array function

array_append(): append element onto end of array. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_dims() — PostgreSQL array function

array_dims(): array dimensions. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_fill() — PostgreSQL array function

array_fill(): array constructor with value. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_length() — PostgreSQL array function

array_length(): array length. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_lower() — PostgreSQL array function

array_lower(): array lower dimension. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_ndims() — PostgreSQL array function

array_ndims(): number of array dimensions. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_position() — PostgreSQL array function

array_position(): returns an offset of value in array. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_positions() — PostgreSQL array function

array_positions(): returns an array of offsets of some value in array. PostgreSQL array functions — signature, volatility, version applicability and…

array_prepend() — PostgreSQL array function

array_prepend(): prepend element onto front of array. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_remove() — PostgreSQL array function

array_remove(): remove any occurrences of an element from an array. PostgreSQL array functions — signature, volatility, version applicability and an…