Skip to contents

DuckDB function range

Source: R/duckdb-funs.R
range.Rd

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

Arguments

col0

BIGINT | TIMESTAMP

col1

BIGINT | TIMESTAMP

col2

BIGINT | INTERVAL

start

BIGINT | TIMESTAMP | TIMESTAMP WITH TIME ZONE

stop

BIGINT | TIMESTAMP | TIMESTAMP WITH TIME ZONE

step

BIGINT | INTERVAL

Value

BIGINT[] | TIMESTAMP[] | TIMESTAMP WITH TIME ZONE[]

Overloads

  • range(col0 = BIGINT)

  • range(col0 = BIGINT, col1 = BIGINT)

  • range(col0 = BIGINT, col1 = BIGINT, col2 = BIGINT)

  • range(col0 = TIMESTAMP, col1 = TIMESTAMP, col2 = INTERVAL)

  • range(start = BIGINT)

  • range(start = BIGINT, stop = BIGINT)

  • range(start = BIGINT, stop = BIGINT, step = BIGINT)

  • range(start = TIMESTAMP, stop = TIMESTAMP, step = INTERVAL)

  • range(start = `TIMESTAMP WITH TIME ZONE`, stop = `TIMESTAMP WITH TIME ZONE`, step = INTERVAL)

SQL examples

range(2, 5, 3)

See also

Other list: array_extract(), array_length(), concat(), contains(), flatten(), generate_series(), len(), list_aggregate(), list_concat(), list_contains(), list_cosine_distance(), list_cosine_similarity(), list_distance(), list_distinct(), list_extract(), list_filter(), list_grade_up(), list_has_all(), list_has_any(), list_inner_product(), list_intersect(), list_negative_inner_product(), list_position(), list_reduce(), list_resize(), list_reverse_sort(), list_select(), list_slice(), list_sort(), list_transform(), list_unique(), list_value(), list_where(), list_zip(), or–or, repeat(), unpivot_list()