Functions/Lists & arrays/array_indexof
Lists & arrays Scalar

array_indexof()

Returns the index of the element if the list contains the element. If the element is not found, it returns NULL.

Alias of list_position()

Arguments & returns

array_indexof(list, element)

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

Example

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

Engine example · Run to view results.

Catalog examples

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