On 1/23/07, Jorge Godoy <jgodoy(at)gmail(dot)com> wrote:
>
> > select cal.date, coalesce(foo.x, 0) AS x
> > from (select (date_trunc('day', current_timestamp) + (s.s * interval '1
> > day'))::date AS date
> > from generate_series(1,365) AS s) AS cal
> > left join foo ON cal.date = foo.create_date;
>
> Why not, for the date part, the simpler alternative:
>
> SELECT CURRENT_DATE + s.s AS DATE FROM generate_series(1, 365) AS s;
>
That's one of the problems with having a couple dozen date/time functions
;).
--
Chad
http://www.postgresqlforums.com/