Lists & arrays Scalar

array_slice()

list_slice with added step feature.

Arguments & returns

2 overloads

Scalar

Extracts a sublist or substring using slice conventions. Negative values are accepted.

Overload link	`list`	`begin`	`end`	Returns
#01	`ANY`	`ANY`	`ANY`	`ANY`

Scalar

Overload link	`list`	`begin`	`end`	`step`	Returns
#02	`ANY`	`ANY`	`ANY`	`BIGINT`	`ANY`

SELECT array_slice([4, 5, 6], 1, 3, 2);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT array_slice('DuckDB', 3, 4);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT array_slice('DuckDB', 3, NULL);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT array_slice('DuckDB', 0, -3);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

ARRAY_SLICE(arr, s, e)

In Haybarn

ARRAY_SLICE(arr, CASE WHEN s >= 0 THEN s + 1 ELSE s END, CASE WHEN e < 0 THEN e - 1 ELSE e END)