Hi,
What about cast to numeric?
select 6.1::numeric-6::numeric ;
?column?
----------
0.1
(1 row)
Regards,
Kaloyan Iliev
Hengki Suhartoyo wrote:
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.
<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index>
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
