Re: 8.3 vs HEAD difference in Interval output? - Mailing list pgsql-hackers

>>> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote: 
> I find the results on 8.3.3 with integer timestamps surprising:
Even more surprising is the behavior for interval(1) here:
ccdev=# select '1 year 2 mons 3 days 04:05:06.64321'::interval;             interval
-------------------------------------1 year 2 mons 3 days 04:05:06.64321
(1 row)

ccdev=# select '1 year 2 mons 3 days 04:05:06.64321'::interval(1);            interval
----------------------------------1 year 2 mons 3 days 04:05:06.60
(1 row)

ccdev=# select '1 year 2 mons 3 days 04:05:06.64321'::interval(2);            interval
----------------------------------1 year 2 mons 3 days 04:05:06.64
(1 row)

ccdev=# select '1 year 2 mons 3 days 04:05:06.64321'::interval(3);            interval
-----------------------------------1 year 2 mons 3 days 04:05:06.643
(1 row)
etc.
That trailing zero should be considered a bug.
-Kevin