Functions/Lists & arrays/array_has
Lists & arrays Scalar

array_has()

Returns true if the list contains the element.

Alias of list_contains()

Arguments & returns

array_has(list, element)

Scalar
Overload link listelement Returns
#01 ANY[]ANY BOOLEAN

Example

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

Engine example · Run to view results.

Catalog examples

SELECT
  list_contains([1, 2, NULL], 1);