Re: round() function wrong? - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: round() function wrong?
Date
Msg-id Pine.LNX.4.33.0310241152440.25425-100000@css120.ihs.com
Whole thread Raw
In response to round() function wrong?  ("Jochen Westland [invigo]" <jochen.westland@invigo.de>)
Responses Re: round() function wrong?  (Michael Brusser <michael@synchronicity.com>)
Re: round() function wrong?  (Robert Treat <xzilla@users.sourceforge.net>)
Re: round() function wrong?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
On Wed, 22 Oct 2003, Jochen Westland [invigo] wrote:

> Hi All,
> i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting is already fixed
> in newer versions or not.
> 
> In my version 
> select round(2.5); returns 2;
> select round(2.5000001) returns 3;
> 
> refering to my math professor thats wrong, at least in germany.
> select round(2.5); should return 3

I just tried that on my 7.2.4 and 7.4 beta 4 machines and I get 2 for 
round(2.5)



pgsql-hackers by date:

Previous
From: Jean-Henry Berevoescu
Date:
Subject: Re: Complex/elaborate user-defined base types
Next
From: "Darren King"
Date:
Subject: Re: Dreaming About Redesigning SQL