When I tried to compare a floating value expression, I got strange output like below
>> (1.2 – 1.0) == 0.2
Floating point numbers represent an extremely wide range of values – much wider than their integer counterparts. This is handled through an exponent and mantissa. For this ability, they trade off precision. Think about the case of adding a large floating point number to a small floating point number:
So assume if you are going to store money values as float means, you will loss the precision and it will give you false comparision. On this case use smallest denomination such as cents, and convert the cents to dollors in front end or use a custom Money column type.
We can use Decimal arithmetic which is also useful for general calculation, because it provides the correct comparision for these type of float numbers, where floating point arithmetic often introduces subtle errors because of the conversion between base 10 and base 2.
So, if you need to compare Floats and you are not receiving the expected response, you can use the BigDecimal class instead:
(BigDecimal.new(“1.2″) – BigDecimal(“1.0″)) == BigDecimal(“0.2″)