ARRAY functions

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The SQL standard specifies an ARRAY data type, which allows for nesting collections of scalar values and even ROW expressions.

In order to operate on ARRAY data types, a few functions are made available by jOOQ.

Table of contents

3.11.20.1.

ARRAY_ALL_MATCH

3.11.20.2.

ARRAY_ANY_MATCH

3.11.20.3.

ARRAY_APPEND (|| operator)

3.11.20.4.

ARRAY_CONCAT (|| operator)

3.11.20.5.

ARRAY_CONTAINS (new)

3.11.20.6.

ARRAY_FILTER

3.11.20.7.

ARRAY_GET

3.11.20.8.

ARRAY_MAP

3.11.20.9.

ARRAY_NONE_MATCH

3.11.20.10.

ARRAY_OVERLAP

3.11.20.11.

ARRAY_PREPEND (|| operator)

3.11.20.12.

ARRAY_REMOVE

3.11.20.13.

ARRAY_REPLACE

3.11.20.14.

ARRAY_REVERSE (new)

3.11.20.15.

ARRAY constructor

3.11.20.16.

ARRAY constructor from subquery

3.11.20.17.

CARDINALITY