"Pablo Oses" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
