Subject Double precision field problem
Author ibrahim bulut
i am in trouble double precision field with subtract operation

field1 is double precision

field2 is double precision

field1's value is 79.69

field2's value is 78.12

when i subtract field2 from field1 with this sql statement

select field1 - field2 from table1

the result is 1,56999999999999

the result must be 1,57

what is the problem

ibrahim bulut

software and database expert

iletisim online ltd.sti.

turkish republic

[Non-text portions of this message have been removed]