On Thu, Mar 16, 2006 at 10:31:54 +1100, Chris <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
