After reading the FAQ and type information over, I went and tried the following:
CREATE TABLE M (A numeric, B text); INSERT INTO M VALUES (1.2); INSERT INTO M VALUES (1.2); INSERT INTO M VALUES (1.2); . . ; did this about 45 times . . SELECT SUM(A) FROM M;
result was 52.800000000001
....
Is there a work around to accurately add fixed point numbers?
You mean like rounding once in a while to the number of significant decimal places? Once every few billion additions like those above should suffice.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]