Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Float8 precision problem
- From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
- To: Hengki Suhartoyo <hengman03(at)yahoo(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Float8 precision problem
- Date: Thu, 30 Nov 2006 20:21:12 +0900
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
- References:
- Float8 precision problem
- From: Hengki Suhartoyo
- Float8 precision problem
- Prev by Date: Re: postgresql 8.2 rc1 - crash
- Next by Date: Erorr in running create set command
- Previous by thread: Re: Float8 precision problem
- Next by thread: Re: Float8 precision problem
- Indexes: