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

From Robert Treat
Subject Re: round() function wrong?
Date
Msg-id 1067022461.2070.14928.camel@camel
Whole thread Raw
In response to Re: round() function wrong?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-hackers
On Fri, 2003-10-24 at 13:53, scott.marlowe wrote:
> 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)
> 

architecture dependent?

qqq74=# select round(2.5), version();round |                            version                             
-------+----------------------------------------------------------------    3 | PostgreSQL 7.4beta4 on
i686-pc-linux-gnu,compiled by GCC 2.96
 
(1 row)

qqq74=# \q
[rob@camel bin]$ uname -a 
Linux camel 2.4.20-20.7 #1 Mon Aug 18 15:00:59 EDT 2003 i686 unknown
[rob@camel bin]$ 

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL



pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Re: Dreaming About Redesigning SQL
Next
From: Marko Karppinen
Date:
Subject: Re: Call for port reports