round(50.5) = 50

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

Responses

Browse pgsql-bugs by date

  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