Re: SUM and NULL values
You could write a stored procedure that converts any NULL to
zero. While this would get you around the problem, it slows
down the query and eliminates any use of parallel query
feature. The procedure would look like this:
CREATE PROCEDURE NULLtoZERO (incolumn INTEGER) RETURNING INTEGER;
DEFINE outvalue INTEGER;
IF incolumn IS NULL THEN
LET outvalue = 0;
ELSE
LET outvalue = incolumn;
END IF;
RETURN outvalue;
END PROCEDURE;
Then use it like this:
select sum(nulltozero(a)) + sum(nulltozero(b)) + sum(nulltozero(c))
from anytable;
Good Luck!
-------------------------------------------------------------------
Jeff Craig | dbINTELLECT Technologies, Inc.
Senior Consultant | Golden, CO
| (303) 275-6954 ext. 8008
| email: settler@dbintellect.com
| fax: (303) 275-2134
-------------------------------------------------------------------