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
---------------------------(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
match