# 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. [EMAIL PROTECTED]
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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
