Michael Glaesemann <[EMAIL PROTECTED]> writes:
> Please find attached diffs for documentation and simple regression
> tests for the new interval->day changes.
The buildfarm results suggest that justify_days is broken in the
integer-datetimes case, eg from panda:
*** ./expected/interval.out Sat Jul 30 16:20:48 2005
--- ./results/interval.out Sat Jul 30 16:24:31 2005
***************
*** 238,243 ****
SELECT justify_days(interval '6 months 36 days 5 hours 4 minutes 3 seconds')
as "7 mons 6 days 5 hours 4 mins 3 seconds";
7 mons 6 days 5 hours 4 mins 3 seconds
----------------------------------------
! @ 7 mons 6 days 5 hours 4 mins 3 secs
(1 row)
--- 238,243 ----
SELECT justify_days(interval '6 months 36 days 5 hours 4 minutes 3 seconds')
as "7 mons 6 days 5 hours 4 mins 3 seconds";
7 mons 6 days 5 hours 4 mins 3 seconds
----------------------------------------
! @ 1 mon 186 days 5 hours 4 mins 3 secs
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster