From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "He Weiping(Laser Henry)" <laser(at)zhengmai(dot)com(dot)cn> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: some errors and/or bugs? |
Date: | 2000-12-19 01:02:49 |
Message-ID: | 2639.977187769@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
"He Weiping(Laser Henry)" <laser(at)zhengmai(dot)com(dot)cn> writes:
> laser_zh=# select round(42.5);
> round
> -------
> 42
> (1 row)
>
> is it correct? I think result should be 43.
It's correct, if the underlying float arithmetic is IEEE-compliant.
Rounding for exact half-integral values is supposed to be "round to
nearest even". So 42.5 goes to 42, but 43.5 goes to 44.
I notice our NUMERIC rounding code does not do that ... perhaps it
should.
Also, the numeric round() function is just plain broken:
regression=# select round(42.5::numeric);
ERROR: Function 'numeric_round(numeric, int4)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
regression=# select round(42.5::numeric,0);
round
-------
43
(1 row)
Looks like a silly oversight in the pg_proc entry for round(numeric).
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Kirkpatrick | 2000-12-19 01:59:34 | Re: 7.1 features list |
Previous Message | He Weiping(Laser Henry) | 2000-12-19 00:48:30 | some errors and/or bugs? |