On Fri, Jul 13, 2001 at 05:11:25PM -0400, Tom Lane wrote:
[..]
> Yeah, for some unfathomable reason SQL92 defines SUM() of no rows to
> return NULL, rather than zero as any mathematician would say it should.
>
> Use COALESCE(SUM(...), 0) to replace the null result by 0.
>
> regards, tom lane
That did the trick. Thanks!
--
Henry House
OpenPGP key available from http://romana.hajhouse.org/hajhouse.asc