list_extract()

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

Reference: DuckDB 2.0.0

Arguments & returns

2 overloads

list_extract(list, index)

Scalar
Overload link listindex Returns
#01 T[]BIGINT T

list_extract(string, index)

Scalar
Overload link stringindex Returns
#02 VARCHARBIGINT VARCHAR

Example

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

Engine example · Run to view results.