Skip site navigation (1)
Skip section navigation (2)
Want to start your own business? Learn how on Yahoo! Small Business.
Peripheral Links
Header And Logo
|
Site Navigation
Float8 precision problem
- From: Hengki Suhartoyo <hengman03(at)yahoo(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Float8 precision problem
- Date: Thu, 30 Nov 2006 02:56:08 -0800 (PST)
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....
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.
- Follow-Ups:
- Re: Float8 precision problem
- From: Kaloyan Iliev
- Re: Float8 precision problem
- From: Michael Glaesemann
- Re: Float8 precision problem
- From: Dann Corbit
- Re: Float8 precision problem
- Prev by Date: postgresql 8.2 rc1 - crash
- Next by Date: Re: Float8 precision problem
- Previous by thread: postgresql 8.2 rc1 - crash
- Next by thread: Re: Float8 precision problem
- Indexes: