Available in versions: Dev (3.21) | Latest (3.20) | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
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.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_FILTER
- 3.11.20.6.
- ARRAY_GET
- 3.11.20.7.
- ARRAY_MAP
- 3.11.20.8.
- ARRAY_NONE_MATCH
- 3.11.20.9.
- ARRAY_OVERLAP
- 3.11.20.10.
- ARRAY_PREPEND (|| operator)
- 3.11.20.11.
- ARRAY_REMOVE
- 3.11.20.12.
- ARRAY_REPLACE
- 3.11.20.13.
- ARRAY constructor
- 3.11.20.14.
- ARRAY constructor from subquery
- 3.11.20.15.
- CARDINALITY
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!