Skip site navigation (1) Skip section navigation (2)

Re: Interval aggregate regression failure (expected seems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Paesold <mpaesold(at)gmx(dot)at>
Cc: Michael Glaesemann <grzm(at)myrealbox(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Interval aggregate regression failure (expected seems
Date: 2005-11-08 22:48:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches
Michael Paesold <mpaesold(at)gmx(dot)at> writes:
> Would you mind reporting this to RedHat Bugzilla? I believe a bug report 
> from you would have more weight then mine, because you actually 
> understand what's going on here. :-)

Actually, given the thought that this may be an artifact of keeping an
intermediate value in a wider-than-normal register rather than genuinely
rearranging the computation, I'm not certain it is a compiler bug.
We'd have to study it a lot more closely before filing it as one, anyway.

If you accept the idea that the pentium4 answer is the right one,
then what we really need to do is focus on a better rounding rule than
"strict truncation".  I was toying with the notion of adding the
equivalent of half a microsecond to the fractional-day value before
truncating it to integer.  But I'm not certain that that wouldn't have
some bad effects in other cases.

			regards, tom lane

In response to


pgsql-hackers by date

Next:From: Gevik babakhaniDate: 2005-11-08 23:07:44
Subject: compiling on windows with mingw
Previous:From: Tom LaneDate: 2005-11-08 22:12:52
Subject: Re: [HACKERS] Troubles with array_ref

pgsql-patches by date

Next:From: Atsushi OgawaDate: 2005-11-09 13:01:40
Subject: Re: Improve the comparison of NUMERIC data
Previous:From: Michael PaesoldDate: 2005-11-08 21:13:17
Subject: Re: Interval aggregate regression failure (expected seems

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group