Is this non-datetime integer only or both? I cannot reproduce the failure here.
--------------------------------------------------------------------------- Michael Glaesemann wrote: > > On Sep 3, 2006, at 12:34 , Bruce Momjian wrote: > > > OK, I worked with Michael and I think this is the best we are going to > > do to fix this. It has one TSROUND call for Powerpc, and that is > > documented. Applied. > > As I was working up regression tests, I found a case that this patch > doesn't handle. > > select interval '4 mon' * .3 as product_h; > product_h > ----------------------- > 1 mon 5 days 24:00:00 > (1 row) > > This should be 1 mon 6 days. It fails for any number of months > greater than 3 that is not evenly divisible by 10, greater than 3 > months. Do we need to look at the month remainder separately? > > Michael Glaesemann > grzm seespotcode net -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq