Series Generating Functions

select * from generate_series(2,4);

select * from generate_series(5,1,-2);

select current_date + s.a as dates from generate_series(0,14,7) as s(a);



Ref : http://www.postgresql.org/docs/8.3/interactive/functions-srf.html