Having something that generates a list of dates would be handy, however I guess you can do it with the current series generator by adding that many day intervals to a base date...
Seems to work:
regression=# select current_date + s.a as dates from generate_series(1,3) as s(a);
dates
------------
2004-02-05
2004-02-06
2004-02-07
(3 rows)
Or even:
regression=# select current_date + s.a * '1 week'::interval as dates from generate_series(1,3) as s(a);
dates
---------------------
2004-02-11 00:00:00
2004-02-18 00:00:00
2004-02-25 00:00:00
(3 rows)
Joe
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]Advertising
