Lists & arrays Scalar

array_position()

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

Arguments & returns

Scalar

Overload link	`list`	`element`	Returns
#01	`T[]`	`T`	`INTEGER`

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT ARRAY_POSITION(2, ARRAY_CONSTRUCT(1, 2, 3))

In DuckDB

SELECT ARRAY_POSITION([1, 2, 3], 2) - 1