Re: SUM() changed in 3.23?

[Sasha Pachev]

Balint TOTH wrote:
> 
> Hi All!
> 
> Is it OK if sum(field) returns NULL if the table has no records? Older
> versions (like 3.22.22) returned 0.
> 
> thanx!
> 
> ---Balint Toth
> 

This is more logical, I think. If this is not what you want, you can do
ifnull(sum(field), 0)
-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)