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>