Re: sum(a*b) returns null

Posted in 1997

Michal Hajek — Fri, 19 Dec 1997 07:39:19 +0100 — source: Informix-list mailing list archive (1991-1998)

Scott Black wrote: > We have the following: > > select sum(a*b) from table > > This does not filter out nulls... > > Is this a bug, or is this how it is supposed to work? > Any views, opinions? > > TIA OnLine v.5.10 - the same. I would use "where a is not null and b is not null" statement. But I guess if "a" is to be number, there should be "0", not null. Nulls may make weird things in calculating ! Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------