From: | Philipp Matthias Hahn <Philipp(dot)Hahn(at)informatik(dot)uni-oldenburg(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | round(50.5) = 50 |
Date: | 2004-02-27 08:38:21 |
Message-ID: | 403F01FD.7040901@informatik.uni-oldenburg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)Hahn(at)informatik(dot)uni-oldenburg(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | PostgreSQL Bugs List | 2004-02-27 11:40:07 | BUG #1086: lower and upper functions |
Previous Message | Tom Lane | 2004-02-27 06:00:15 | Re: intermittent error: 'variable not found in subplan target list' - INCOMPLETE SUBMISSION |