Re: round() function wrong?
От | Robert Treat |
---|---|
Тема | Re: round() function wrong? |
Дата | |
Msg-id | 1067022461.2070.14928.camel@camel обсуждение исходный текст |
Ответ на | Re: round() function wrong? ("scott.marlowe" <scott.marlowe@ihs.com>) |
Список | 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 по дате отправления: