range()
Creates a list of values between start and stop - the stop parameter is exclusive.
Reference: DuckDB 2.0.0
Arguments & returns
10 overloadsrange(stop)
Scalar
| Overload link | stop |
Returns |
|---|---|---|
| #01 | BIGINT |
BIGINT[] |
range(start, stop)
Scalar
| Overload link | start | stop |
Returns |
|---|---|---|---|
| #02 | BIGINT | BIGINT |
BIGINT[] |
range(start, stop, step)
Scalar
range(stop)
Table
| Overload link | stop |
Returns |
|---|---|---|
| #06 | BIGINT |
TABLE |
range(start, stop)
Table
| Overload link | start | stop |
Returns |
|---|---|---|---|
| #07 | BIGINT | BIGINT |
TABLE |
range(start, stop, step)
Table
Example
Haybarn WASM 2.0.0-rc12 ยท In your browser
Engine example ยท Run to view results.
In a query
Make a small dataset from nothing.
A table function produces rows you can query. range starts at zero and stops before the upper bound.
Haybarn WASM 2.0.0-rc12 ยท In your browser
Guide recipe ยท Run to view results.
In other engines
Snowflakearray_generate_range()
ARRAY_GENERATE_RANGE(0, 3)
RANGE(0, 3)