ARRAY functions

Applies to ✅ 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.17.1.

ARRAY_APPEND (|| operator)

3.11.17.2.

ARRAY_CONCAT (|| operator)

3.11.17.3.

ARRAY_GET

3.11.17.4.

ARRAY_OVERLAP

3.11.17.5.

ARRAY_PREPEND (|| operator)

3.11.17.6.

ARRAY_REMOVE

3.11.17.7.

ARRAY_REPLACE

3.11.17.8.

ARRAY constructor

3.11.17.9.

ARRAY constructor from subquery

3.11.17.10.

CARDINALITY