From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | sferac(at)bo(dot)nettuno(dot)it |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] 123.45 - 123 = 0.45 |
Date: | 1998-12-15 14:27:03 |
Message-ID: | 199812151427.JAA14246@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | David Hartwig | 1998-12-15 14:55:24 | Re: [SQL] MINUS and slow 'not in' |
Previous Message | Sferacarta Software | 1998-12-15 13:43:20 | Re[2]: [HACKERS] JOIN syntax. Examples? |