Re: numeric and float converts to int differently?
От | SZUCS Gábor |
---|---|
Тема | Re: numeric and float converts to int differently? |
Дата | |
Msg-id | 0acb01c39d90$6d9d9080$0403a8c0@fejleszt4 обсуждение исходный текст |
Ответ на | numeric and float converts to int differently? ("SZŰCS Gábor" <surrano@mailbox.hu>) |
Ответы |
Re: numeric and float converts to int differently?
|
Список | pgsql-sql |
----- Original Message ----- From: "Greg Stark" <gsstark@mit.edu> Sent: Tuesday, October 28, 2003 7:21 PM > > > cannot see is that the float values are not actually exactly 0.5 > > > > Yes I could guess that (floating point vs fixed), but is this a coincidence > > that both '0.5'::float and '-0.5'::float are closer to 0, whereas they could > > be closer to +/-1, as well as both closer to the lower or upper bound. > > Wouldn't 0.5 and -0.5 be representable exactly as floats? As Tom pointed out, it isn't a floating point failure -- it is how rounding float is implemented. I assume anything with less than 15 digits can be exactly represented as float. G. ------------------------------- cut here -------------------------------
В списке pgsql-sql по дате отправления: