Lists & arrays Scalar

list_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	`ANY[]`	`ANY`	`INTEGER`

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.