Available in versions: Dev (3.20) | Latest (3.19) | 3.18

ARRAY_OVERLAP

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The ARRAY_OVERLAP function allows for checking if two arrays overlap:

SELECT ARRAY[1, 2] && ARRAY[3, 4]
create.select(arrayOverlap(array(1, 2), array(2, 3))).fetch();

The result would look like this:

+---------------+
| array_overlap |
+---------------+
| true          |
+---------------+
arrayOverlap(array(1, 2), array(2, 3))

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo