Subject Rounding Problems
Author Marcos Vinicius Dufloth
Hi list.
I have a problem with numeric fields and rounding. In database, there is a value stored in a numeric(15,4) field equals to 16.7200. Inside a trigger, when this value is moved to a variable, also numeric(15,4), it turns 16.7199999999989 causing some problems to me. I read that numeric types have exactly N digits of precision. Whi this is happening?


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