Function Category: Array Functions

array_replace() — PostgreSQL array function

array_replace(): replace any occurrences of an element in an array. PostgreSQL array functions — signature, volatility, version applicability and an…

array_reverse() — PostgreSQL array function

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

array_sample() — PostgreSQL array function

array_sample(): take samples from array. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_shuffle() — PostgreSQL array function

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

array_sort() — PostgreSQL array function

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

array_subscript_handler() — PostgreSQL array function

array_subscript_handler(): standard array subscripting support. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_to_string() — PostgreSQL array function

array_to_string(): concatenate array elements, using delimiter, into text. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

array_upper() — PostgreSQL array function

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

arraycontjoinsel() — PostgreSQL array function

arraycontjoinsel(): join selectivity for array-containment operators. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

arraycontsel() — PostgreSQL array function

arraycontsel(): restriction selectivity for array-containment operators. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.