Re: [GENERAL] Rounding incompatibility

2009-06-16 Thread Havasvölgyi Ottó
Yes, they are both your packages from your official site. So this means that in 8.2 and in earlier versions the rounding is not the regular one. Best regards, Otto 2009/6/15 Dave Page > On Mon, Jun 15, 2009 at 3:33 PM, Tom Lane wrote: > > =?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= > writes: > >> I

Re: [GENERAL] Rounding incompatibility

2009-06-15 Thread Dave Page
On Mon, Jun 15, 2009 at 3:33 PM, Tom Lane wrote: > =?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= writes: >> I have found the following strangeness on Windows versions: > > Were your two versions built different ways (perhaps with different > compilers)?  This comes down to what the system-supplied rint()

Re: [GENERAL] Rounding incompatibility

2009-06-15 Thread Gurjeet Singh
On Mon, Jun 15, 2009 at 4:28 PM, Havasvölgyi Ottó < havasvolgyi.o...@gmail.com> wrote: > Hi, > > I have found the following strangeness on Windows versions: > > create table round_test (id int primary key, value double precision); > insert into round_test(id, value) values(1, 1.5); > insert into r

Re: [GENERAL] Rounding incompatibility

2009-06-15 Thread Tom Lane
=?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= writes: > I have found the following strangeness on Windows versions: Were your two versions built different ways (perhaps with different compilers)? This comes down to what the system-supplied rint() function does. regards, tom lane

[GENERAL] Rounding incompatibility

2009-06-15 Thread Havasvölgyi Ottó
Hi, I have found the following strangeness on Windows versions: create table round_test (id int primary key, value double precision); insert into round_test(id, value) values(1, 1.5); insert into round_test(id, value) values(2, -1.5); insert into round_test(id, value) values(3, 3.5); select round