Lists & arrays Scalar

list_has_all()

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

Arguments & returns

Scalar

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

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.