list_position()

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

Reference: DuckDB 2.0.0

Arguments & returns

list_position(list, element)

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

Example

list_position example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.