Function Category: Array Functions

trim_array() — PostgreSQL array function

trim_array(): remove last N elements of array. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

unnest() — PostgreSQL array function

unnest(): expand array to set of rows. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

varbittypmodin() — PostgreSQL array function

varbittypmodin(): I/O typmod. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

varchartypmodin() — PostgreSQL array function

varchartypmodin(): I/O typmod. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

xpath() — PostgreSQL array function

xpath(): evaluate XPath expression, with namespaces support. PostgreSQL array functions — signature, volatility, version applicability and an illustrative example.

xpath_exists() — PostgreSQL array function

xpath_exists(): test XML value against XPath expression, with namespace support. PostgreSQL array functions — signature, volatility, version applicability and an…