Generate a series of integers or decimals.


generate_series(<start>, <stop> [, <step>])
Field Description
start The integer or decimals to start generating from.
stop The integer or decimals to stop generating at.
step The step size (defaults to 1).


The following generates even numbers from 0 to 10.

select * from generate_series(0, 10, 2);

The following generates decimals from 0.0 to 1.0, stepping by 0.1:

select * from generate_series(0, 1, 0.1);