round(50.5) = 50
| От | Philipp Matthias Hahn |
|---|---|
| Тема | round(50.5) = 50 |
| Дата | |
| Msg-id | 403F01FD.7040901@informatik.uni-oldenburg.de обсуждение исходный текст |
| Ответы |
Re: round(50.5) = 50
|
| Список | pgsql-bugs |
Hello!
# SELECT round(5.5::float4),round(50.5::float4);
round | round
-------+-------
6 | 50
(1 row)
I think this is a bug, since I would expect 6 and 51. Doing the same
without the float4-cast, it works correct. This bug bites me while
passing parameters to a plpgsql function.
This happens both with Debian 7.3.4-9 and 7.4.1-3
Is this a real bug or am I missing something? A bug fix or work-around
would be nice.
BYtE
Philipp
--
Dipl.-Inform. Philipp.Hahn@informatik.uni-oldenburg.de
Abteilung Systemsoftware und verteilte Systeme, Fk. II
Carl von Ossietzky Universitaet Oldenburg, 26111 Oldenburg, Germany
http://www.svs.informatik.uni-oldenburg.de/contact/pmhahn/
Telefon: +49 441 798-2866 Telefax: +49 441 798-2756
В списке pgsql-bugs по дате отправления: