postgres=# select current_date + s.a as dates from generate_series(0,14,7) as s(a); dates------------ 2006-10-19 2006-10-26 2006-11-02(3 rows)postgres=#postgres=#