Re: BUG #1888: bug in cast from float4 to float8 - Mailing list pgsql-bugs

"Pablo Oses" <opablo@gmail.com> writes:
> 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

This is not a bug.  Please go learn something about floating-point
arithmetic (or if you don't care to, use type numeric instead).

            regards, tom lane