Lists & arrays Scalar

array_extract()

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

Arguments & returns

4 overloads

Scalar

Overload link	`list`	`index`	Returns
#01	`ANY[]`	`BIGINT`	`ANY`
#02	`STRUCT`	`BIGINT`	`ANY`
#03	`STRUCT`	`VARCHAR`	`ANY`
#04	`VARCHAR`	`BIGINT`	`VARCHAR`

SELECT array_extract('DuckDB', 2);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT array_extract({'i': 3, 'v2': 3, 'v3': 0}, 'i');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT array_extract(row(42, 84), 1);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT REGEXP_EXTRACT(abc, 'pattern(group)', 2, 3) FROM table

In DuckDB

SELECT ARRAY_EXTRACT(REGEXP_EXTRACT_ALL(NULLIF(SUBSTRING(abc, 2), ''), 'pattern(group)', 1), 3) FROM "table"

REGEXP_SUBSTR(subject, pattern, 1, 2)

In DuckDB

ARRAY_EXTRACT(REGEXP_EXTRACT_ALL(subject, pattern), 2)