Re: [HACKERS] Interval aggregate regression failure (expected seems

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paesold <mpaesold(at)gmx(dot)at>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] Interval aggregate regression failure (expected seems
Date: 2006-08-30 13:20:58
Message-ID: 4C0184B3-8BFD-40C3-ABD7-8819B18CE103@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


On Aug 30, 2006, at 12:50 , Bruce Momjian wrote:

> Yea, I see that -122:23:60.00.

After applying your patch, I believe that on my machine it's the
contribution from the day component that is producing the 23:60.00.
For example,

select interval '-12 days' * 0.3;
?column?
----------------------
-3 days -14:23:60.00
(1 row)

I think some kind of rounding needs to be done to the day
contribution as well. I'm continuing to work on it, but wanted to get
this out there.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-08-30 14:14:02 Re: Backend SSL configuration enhancement
Previous Message Victor B. Wagner 2006-08-30 12:28:59 Backend SSL configuration enhancement

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-08-30 14:14:02 Re: Backend SSL configuration enhancement
Previous Message Victor B. Wagner 2006-08-30 12:28:59 Backend SSL configuration enhancement