On 06/26/10 17:09, wrote:
> On 2010-06-25, Lee Hachadoorian<lee.hachadoorian@gmail.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 !