Re: round() function wrong?

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: round() function wrong?
Дата
Msg-id Pine.LNX.4.33.0310241152440.25425-100000@css120.ihs.com
обсуждение исходный текст
Ответ на round() function wrong?  ("Jochen Westland [invigo]" <jochen.westland@invigo.de>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Jean-Henry Berevoescu
Дата:
Сообщение: Re: Complex/elaborate user-defined base types
Следующее
От: "Darren King"
Дата:
Сообщение: Re: Dreaming About Redesigning SQL