| From: | silly sad <sad(at)bankir(dot)ru> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: round(Numeric) |
| Date: | 2010-06-28 05:29:03 |
| Message-ID: | 4C28331F.1080007@bankir.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 06/26/10 17:09, wrote:
> On 2010-06-25, Lee Hachadoorian<lee(dot)hachadoorian(at)gmail(dot)com> wrote:
>> Is it documented anywhere that floating-point numbers round
>> "scientifically", that is 0.5 rounds to the nearest even number?
>
> That's swiss rounding. And no, as I understand it documented that
> most arithmetic) is platform specific.
>
> Postgres is written in C and the relevant portions of the
> C standards douments (and discussions thereof) give a good
> picture of the functioning of postgres arithmetic.
IT IS REALLY SAD !
the round(Numeric) does not behave as Math science prescribes :(
Shame on PostgresQL !
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcin Krawczyk | 2010-06-28 06:46:39 | Re: help |
| Previous Message | Jasen Betts | 2010-06-26 13:18:30 | Re: Round integer division |