On Thu, Mar 16, 2006 at 10:31:54 +1100,
Chris <dmagick@gmail.com> wrote:
> sconeek@gmail.com wrote:
> >i am working on this postgresql statement. it picks up all non-null
> >values only. is there a way to pickup all hour values (if any hour
> >value not existing, still find them and assign their value to be 0).
> >coz my table does not contain all hour values, only ones which have a
> >non-zero value.
> >
> I don't think it's possible. It won't come up with a left outer join
> because you aren't comparing to anything unless you have a second table
> with all of the times you want to compare.
Left joining against the output of generate_series could be used to do this.