GENERATE_SERIES (Beta)
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> ] )
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<start> | The first value in the interval. | BIGINT |
<stop> | The last value in the interval. The series stops once the last generated step value exceeds the stop value. | BIGINT |
<step> | Optional literal integer value to set step. If not included, the default step is 1. | BIGINT |
Return Type
BIGINT
Example
SELECT n, DATE_ADD('DAY', n, '2023-02-02') result
FROM GENERATE_SERIES(1, 10, 2) s(n)
Returns:
| n | result |
|---|---|
| 1 | 2023-02-03 00:00:00 |
| 3 | 2023-02-05 00:00:00 |
| 5 | 2023-02-07 00:00:00 |
| 7 | 2023-02-09 00:00:00 |
| 9 | 2023-02-11 00:00:00 |
Known limitations
GENERATE_SERIES is not supported for all queries - unsupported queries will result in the following message: Planner error: Invalid input error: generate_series() is not supported for this request.