generate_series(0,14,7)
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=#