Lists & arrays Scalar

list_extract()

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

Arguments & returns

2 overloads

Scalar

Overload link	`list`	`index`	Returns
#01	`T[]`	`BIGINT`	`T`
#02	`VARCHAR`	`BIGINT`	`VARCHAR`

SELECT list_extract([4, 5, 6], 3);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.