On Nov 30, 2006, at 19:56 , Hengki Suhartoyo wrote:
> 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
Then use numeric instead of float. Float by its very nature is not
precise.
Michael Glaesemann
grzm seespotcode net