Skip to main content
Skip to main content
Edit this page

generate_series Table Function

Alias: generateSeries

Syntax​

Returns a table with the single 'generate_series' column (UInt64) that contains integers from start to stop inclusively:

Returns a table with the single 'generate_series' column (UInt64) that contains integers from start to stop inclusively with spacing between values given by STEP:

Examples​

The following queries return tables with the same content but different column names:

And the following queries return tables with the same content but different column names (but the second option is more efficient):