Functions/Lists & arrays/array_has_any
Lists & arrays Scalar

array_has_any()

Returns true if the lists have any element in common. NULLs are ignored.

Alias of list_has_any()

Arguments & returns

array_has_any(l1, l2)

Scalar
Overload link l1 l2 Returns
#01 ANY[]ANY[] BOOLEAN

Example

array_has_any example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  list_has_any([1, 2, 3], [2, 3, 4]);