Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
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.19.1.
- ARRAY_ALL_MATCH (new)
- 3.11.19.2.
- ARRAY_ANY_MATCH (new)
- 3.11.19.3.
- ARRAY_APPEND (|| operator)
- 3.11.19.4.
- ARRAY_CONCAT (|| operator)
- 3.11.19.5.
- ARRAY_FILTER (new)
- 3.11.19.6.
- ARRAY_GET
- 3.11.19.7.
- ARRAY_MAP (new)
- 3.11.19.8.
- ARRAY_NONE_MATCH (new)
- 3.11.19.9.
- ARRAY_OVERLAP
- 3.11.19.10.
- ARRAY_PREPEND (|| operator)
- 3.11.19.11.
- ARRAY_REMOVE
- 3.11.19.12.
- ARRAY_REPLACE
- 3.11.19.13.
- ARRAY constructor
- 3.11.19.14.
- ARRAY constructor from subquery
- 3.11.19.15.
- CARDINALITY
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!