Functions/Lists & arrays/list_element
Lists & arrays Scalar

list_element()

Extract the indexth (1-based) value from the list.

Alias of list_extract()

Arguments & returns

2 overloads

list_element(list, index)

Scalar
Overload link listindex Returns
#01 T[]BIGINT T
#02 VARCHARBIGINT VARCHAR

Example

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

Engine example · Run to view results.