generate_series: an Oracle implementation in light of SQL Design Patterns 
(Simon Greener) There is a very useful function in PostgreSQL called generate_series that can be used to generate a series of integer numbers from som start value to and end value with an optional step value.
Read Article >>