List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 19 1999 5:00pm
Subject:Re: SUM() changed in 3.23?
View as plain text  
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)
Thread
SUM() changed in 3.23?Balint TOTH19 Jul
  • Re: SUM() changed in 3.23?Sasha Pachev19 Jul
  • Re: SUM() changed in 3.23?Scott Hess20 Jul
  • Re: SUM() changed in 3.23?Sasha Pachev20 Jul
    • Re: SUM() changed in 3.23?Paul DuBois20 Jul
  • Re: SUM() changed in 3.23?Sasha Pachev20 Jul
    • Re: SUM() changed in 3.23?Michael Widenius30 Jul