Lists & arrays
Scalar
list_element()
Extract the indexth (1-based) value from the list.
Reference: DuckDB 2.0.0
Alias of list_extract()
Arguments & returns
2 overloadslist_element(list, index)
Scalar
| Overload link | list | index |
Returns |
|---|---|---|---|
| #01 | T[] | BIGINT |
T |
list_element(string, index)
Scalar
| Overload link | string | index |
Returns |
|---|---|---|---|
| #02 | VARCHAR | BIGINT |
VARCHAR |
Example
Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.