interval madness ...

hello everybody ...

i am sitting here in a training and i am wondering about the
following issue ...

test=# select now() + '3 years 2 decades 4000 seconds 9
minutes'::interval;
?column?
-------------------------------
2031-06-28 11:58:35.052423+02
(1 row)

test=# select now() + '3 years 2 decades 4000 seconds 9 minutes 1
century'::interval;
?column?
-------------------------------
2131-06-28 11:59:01.635835+01
(1 row)

why do i get a different timezone just because of adding one more
century?
i cannot see an obvious reason.

many thanks,

hans

--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, 2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql-support.de, www.postgresql-support.com