Re: [HACKERS] 123.45 - 123 = 0.45

Oleg Broytmann <phd@sun.med.ru>

From: Oleg Broytmann <phd@sun.med.ru>
To: Sferacarta Software <sferac@bo.nettuno.it>
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-12-15T13:08:48Z
Lists: pgsql-hackers
Hello!

On Tue, 15 Dec 1998, Sferacarta Software wrote:
> 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)

   I cannot understand anything. You said "to divide" and then "123.45 - 123.00".
Are you trying to divide or to substract?

Oleg.
---- 
    Oleg Broytmann  National Research Surgery Centre  http://sun.med.ru/~phd/
           Programmers don't die, they just GOSUB without RETURN.