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 */

使用 jOOQ 3.21 生成。早期 jOOQ 版本的支持可能有所不同。 在我们的网站上翻译您自己的 SQL