Float8 precision problem

[Hengki Suhartoyo <hengman03@xxxxxxxxx>]

Hi all,

I got problem in postgrsql 8.0 when subtraction in float8, this is my query :
select 6.1::float8-6::float8

Result>>> 0.099999999999996

I need the result like natural subtraction is 0.1

Help me please....

---

Want to start your own business? Learn how on Yahoo! Small Business.