> Hi all,
>
> I tried to divide 123.45 by 123.00 but PostgreSQL gives me a wrong
> result:
>
> hygea=> select 123.45 - 123.00;
> ?column?
> -----------------
> 0.450000000000003
> (1 row)
>
Wow, I get the same thing here.
Even this doesn't work:
test=> select float8(123.45) - float8(123.00); ?column?-----------------0.450000000000003(1 row)
Now constants are automatically promoted to float8, so I expected the
same results, but what is going on here?
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026