Re: BUG #1888: bug in cast from float4 to float8

"Pablo Oses"  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