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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
