Hi,
I ran into some strange behavior.Seems like a bug to me?
wbloos=# select round(0.5::numeric), round(0.5::double precision);
round | round
-------+-------
1 | 0
(1 row)
wbloos=# select version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 9.1.13 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.8.1-10ubuntu9) 4.8.1, 64-bit
(1 row)
Cheers,
--
Willy-Bas Loos