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;
-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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not

Reply via email to