generate_series ( start integer, stop integer [, step integer ] ) → setof integerGenerates a series of values from
start to stop, with a step size of step. step defaults to 1.Functions / Set Returning Functions
generate_series
Read the PG 18 manualGenerates a series of values from start to stop, with a step size of step.
Reading PG 18current·documented in 23 of 27 versions, 8.0 to 20
Signatures & examples
generate_series ( start bigint, stop bigint [, step bigint ] ) → setof bigintGenerates a series of values from
start to stop, with a step size of step. step defaults to 1.generate_series ( start numeric, stop numeric [, step numeric ] ) → setof numericGenerates a series of values from
start to stop, with a step size of step. step defaults to 1.generate_series ( start timestamp, stop timestamp, step interval ) → setof timestampGenerates a series of values from
start to stop, with a step size of step. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the timezone argument, or the current TimeZone setting if that is omitted.generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ) → setof timestamp with time zoneGenerates a series of values from
start to stop, with a step size of step. In the timezone-aware form, times of day and daylight-savings adjustments are computed according to the time zone named by the timezone argument, or the current TimeZone setting if that is omitted.Definition snapshot: b7bd9cda · English manual source