Re: [HACKERS] 123.45 - 123 = 0.45

> 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, Pennsylvania 19026