DuckDB function array_position

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

Usage

array_position(list = `T[]`, element = T)

Arguments

list

T[]

element

T

Value

INTEGER

SQL examples

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