Functions/Lists & arrays/array_has_all
Lists & arrays Scalar

array_has_all()

Returns true if all elements of list2 are in list1. NULLs are ignored.

Alias of list_has_all()

Arguments & returns

array_has_all(list1, list2)

Scalar
Overload link list1list2 Returns
#01 T[]T[] BOOLEAN

Example

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

Engine example · Run to view results.