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