Re: 8.3 vs HEAD difference in Interval output?
От | Kevin Grittner |
---|---|
Тема | Re: 8.3 vs HEAD difference in Interval output? |
Дата | |
Msg-id | 48CE979F.EE98.0025.0@wicourts.gov обсуждение исходный текст |
Ответ на | Re: 8.3 vs HEAD difference in Interval output? ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
Ответы |
Re: 8.3 vs HEAD difference in Interval output?
|
Список | 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
В списке pgsql-hackers по дате отправления: