Skip to contents

DuckDB function generate_series

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

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

Usage

generate_series(start, stop, step)

Arguments

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

  • generate_series(col0 = BIGINT)

  • generate_series(col0 = BIGINT, col1 = BIGINT)

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

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

  • generate_series(col0 = `TIMESTAMP WITH TIME ZONE`, col1 = `TIMESTAMP WITH TIME ZONE`, col2 = INTERVAL)

  • generate_series(start = BIGINT)

  • generate_series(start = BIGINT, stop = BIGINT)

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

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

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

Provided by

  • generate_series(col0 = BIGINT): built in

  • generate_series(col0 = BIGINT, col1 = BIGINT): built in

  • generate_series(col0 = BIGINT, col1 = BIGINT, col2 = BIGINT): built in

  • generate_series(col0 = TIMESTAMP, col1 = TIMESTAMP, col2 = INTERVAL): built in

  • generate_series(col0 = `TIMESTAMP WITH TIME ZONE`, col1 = `TIMESTAMP WITH TIME ZONE`, col2 = INTERVAL): icu

  • generate_series(start = BIGINT): built in

  • generate_series(start = BIGINT, stop = BIGINT): built in

  • generate_series(start = BIGINT, stop = BIGINT, step = BIGINT): built in

  • generate_series(start = TIMESTAMP, stop = TIMESTAMP, step = INTERVAL): built in

  • generate_series(start = `TIMESTAMP WITH TIME ZONE`, stop = `TIMESTAMP WITH TIME ZONE`, step = INTERVAL): built in

SQL examples

generate_series(2, 5, 3)

See also

Other list: array_extract(), array_length(), concat(), contains(), flatten(), 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, range(), repeat(), unpivot_list()