Hi!
Is there a simple way to generate sequences of dates like the following?
"2008-07-03 00:00:00"
"2008-07-04 00:00:00"
"2008-07-05 00:00:00"
"2008-07-06 00:00:00"
I'd like to join a table to aggregate the number of items for each day
(each item has a timestamp).
For some days however there are no items, resulting in no row instead of
a row with zero items.
I'd like to fill these empty rows.
I hope I could make my problem clear?!
Best regards
Patrick
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
