Functions/Lists & arrays/range
Lists & arrays Scalar Table

range()

Creates a list of values between start and stop - the stop parameter is exclusive.

Arguments & returns

10 overloads

range(start)

Scalar
Overload link start Returns
#01 BIGINT BIGINT[]

range(start, stop)

Scalar
Overload link startstop Returns
#02 BIGINTBIGINT BIGINT[]

range(start, stop, step)

Scalar
Overload link startstopstep Returns
#03 BIGINTBIGINTBIGINT BIGINT[]
#04 TIMESTAMP WITH TIME ZONETIMESTAMP WITH TIME ZONEINTERVAL TIMESTAMP WITH TIME ZONE[]
#05 TIMESTAMPTIMESTAMPINTERVAL TIMESTAMP[]

range(col0)

Table
Overload link col0 Returns
#06 BIGINT TABLE

range(col0, col1)

Table
Overload link col0col1 Returns
#07 BIGINTBIGINT TABLE

range(col0, col1, col2)

Table
Overload link col0col1col2 Returns
#08 BIGINTBIGINTBIGINT TABLE
#09 TIMESTAMP WITH TIME ZONETIMESTAMP WITH TIME ZONEINTERVAL TABLE
#10 TIMESTAMPTIMESTAMPINTERVAL TABLE

Example

range example
SQL
Haybarn WASM 1.5.5-rc3 · 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.

Make a small dataset from nothing.
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Guide recipe · Run to view results.

In other engines

Snowflakearray_generate_range()

ARRAY_GENERATE_RANGE(0, 3)
In DuckDB
RANGE(0, 3)

SQLGlot example ↗