Re: Float8 precision problem

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>