Envelope-to: pgsql-sql@postgresql.org
Message-ID: <4C28331F.1080007@bankir.ru>
Date: Mon, 28 Jun 2010 09:29:03 +0400
From: silly sad <sad@bankir.ru>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5)
	Gecko/20100111 Thunderbird/3.0
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: round(Numeric)
References: <4C25334D.4040805@gmail.com> <i04u5h$jc8$1@reversiblemaps.ath.cx>
In-Reply-To: <i04u5h$jc8$1@reversiblemaps.ath.cx>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit

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 !