From: | Lee Hachadoorian <lee(dot)hachadoorian(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Round integer division |
Date: | 2010-06-25 22:53:01 |
Message-ID: | 4C25334D.4040805@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Is it documented anywhere that floating-point numbers round
"scientifically", that is 0.5 rounds to the nearest even number? Compare:
SELECT round(2.5::real), round(2.5::numeric), round(3.5::real),
round(3.5::numeric);
generates
2 | 3 | 4 | 4
I stumbled across this when I was trying to use round(a::real/b::real)
to generate a rounded result to dividing integers, and noticed sometimes
0.5 was truncated and sometimes it was rounded up. Couldn't find
anything about this in the archives or the data type documentation. Is
there something obvious that I'm I missing?
Thanks,
--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-06-25 23:00:40 | Re: Round integer division |
Previous Message | Frank Bax | 2010-06-25 22:23:48 | How do I remove selected words from text field? |