Lists & arrays Scalar

list_slice()

list_slice with added step feature.

Arguments & returns

2 overloads

Scalar

Extract a sublist 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 list_slice([4, 5, 6], 1, 3, 2);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

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

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

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