Functions/Lists & arrays/array_has_all
Lists & arrays Scalar

array_has_all()

Returns true if all elements of l2 are in l1. NULLs are ignored.

Alias of list_has_all()

Arguments & returns

array_has_all(l1, l2)

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

Example

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

Engine example · Run to view results.

Catalog examples

SELECT
  list_has_all([1, 2, 3], [2, 3]);