Re: round() function wrong?

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(at)camel bin]$ uname -a
Linux camel 2.4.20-20.7 #1 Mon Aug 18 15:00:59 EDT 2003 i686 unknown
[rob(at)camel bin]$

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