Re: round() function wrong?

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Jochen Westland [invigo]" <jochen(dot)westland(at)invigo(dot)de>
Cc: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: round() function wrong?
Date: 2003-10-24 17:53:22
Message-ID: Pine.LNX.4.33.0310241152440.25425-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Darren King 2003-10-24 18:15:24 Re: Dreaming About Redesigning SQL
Previous Message Anthony W. Youngman 2003-10-24 17:51:30 Re: Dreaming About Redesigning SQL