Re: [PATCHES] Interval->day docs and regression tests - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] Interval->day docs and regression tests
Date
Msg-id 27443.1122742583@sss.pgh.pa.us
Whole thread Raw
List pgsql-hackers
Michael Glaesemann <grzm@myrealbox.com> 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
4mins 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
4mins 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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Updated open items
Next
From: "Magnus Hagander"
Date:
Subject: Re: Write past chunk end?