GENERATE_SERIES

Generates a single rowset of values from start to stop, with a step size of step. GENERATE_SERIES is a table-valued function.

Syntax

GENERATE_SERIES ( <start>, <stop> [, <step> ] )

Parameter	Description	Supported input types
`<start>`	The first value in the interval.	`BIGINT`, `INTEGER`
`<stop>`	The last value in the interval. The series stops once the last generated step value exceeds the stop value.	`BIGINT`, `INTEGER`
`<step>`	Optional literal integer value to set step. If not included, the default step is 1.	`BIGINT`, `INTEGER`

Setof INTEGER if all operands are of type INTEGER, otherwise setof BIGINT.

SELECT n, DATE_ADD('DAY', n, '2023-02-02') result
FROM GENERATE_SERIES(1, 10, 2) s(n);

Rows: 5Execution time: 5.42ms

⌘I