On Sat, Sep 17, 2005 at 04:00:50AM +0100, Pablo Oses wrote:
> select cast(123.456::float4 as float8)
> what do you think its the answer ? 123.456 ?
> well pgsql 7.2.2, 8.0.0, 8.0.1 and 8.0.3 (all i have used) answers this:
> 123.456001281738 which is WRONG
Float4 has a precision of only about 6 digits, so you can't assume
much about the digits beyond that. See the documentation for
This is hardly a behavior unique to PostgreSQL; use a search engine
to find explanations of the problems of using binary floating-point
If you need exact results then use the numeric type.
In response to
pgsql-bugs by date
|Next:||From: Evgeny Gridasov||Date: 2005-09-17 19:40:10|
|Subject: BUG #1889: little documentation error|
|Previous:||From: Tom Lane||Date: 2005-09-17 13:46:52|
|Subject: Re: BUG #1888: bug in cast from float4 to float8 |