>>> "Kevin Grittner" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
