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
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.16.1.
- ARRAY_APPEND (|| operator) (new)
- 3.11.16.2.
- ARRAY_CONCAT (|| operator) (new)
- 3.11.16.3.
- ARRAY_GET
- 3.11.16.4.
- ARRAY_OVERLAP (new)
- 3.11.16.5.
- ARRAY_PREPEND (|| operator) (new)
- 3.11.16.6.
- ARRAY_REMOVE (new)
- 3.11.16.7.
- ARRAY_REPLACE (new)
- 3.11.16.8.
- ARRAY constructor
- 3.11.16.9.
- ARRAY constructor from subquery
- 3.11.16.10.
- CARDINALITY
previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!