Christopher Kings-Lynne wrote:
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]

Reply via email to