Postgres Pro
Downloads
Home   >   mailing lists

Float8 precision problem - Mailing list pgsql-general

From Hengki Suhartoyo
Subject Float8 precision problem
Date
Msg-id 20061130105608.69500.qmail@web57701.mail.re3.yahoo.com
Whole thread Raw
Responses Re: Float8 precision problem  ("Dann Corbit" <DCorbit@connx.com>)
Re: Float8 precision problem  (Michael Glaesemann <grzm@seespotcode.net>)
Re: Float8 precision problem  (Kaloyan Iliev <news1@faith.digsys.bg>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: postgresql 8.2 rc1 - crash
Next
From: "Dann Corbit"
Date:
Subject: Re: Float8 precision problem