ARRAY_OVERLAP

SELECT ARRAY[1, 2] && ARRAY[3, 4]

create.select(arrayOverlap(array(1, 2), array(2, 3))).fetch();

+---------------+
| array_overlap |
+---------------+
| true          |
+---------------+

arrayOverlap(array(1, 2), array(2, 3))

(ARRAY[1, 2] && ARRAY[2, 3])

arrays_overlap(
  ARRAY(1, 2),
  ARRAY(2, 3)
)

array_length(array_intersect(
  ARRAY[1, 2],
  ARRAY[2, 3]
)) > 0

EXISTS (
  SELECT *
  FROM UNNEST(ARRAY[1, 2]) array_table (COLUMN_VALUE)
  INTERSECT
  SELECT *
  FROM UNNEST(ARRAY[2, 3]) array_table (COLUMN_VALUE)
)

EXISTS (
  SELECT *
  FROM UNNEST(ARRAY[1, 2]) array_table (COLUMN_VALUE)
  INTERSECT ALL
  SELECT *
  FROM UNNEST(ARRAY[2, 3]) array_table (COLUMN_VALUE)
)

arrays_overlap(
  ARRAY[1, 2],
  ARRAY[2, 3]
)

/* UNSUPPORTED */

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website