Re: [HACKERS] interval madness ...

2008-06-28 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Hans-Juergen Schoenig" <[EMAIL PROTECTED]> writes: >> why do i get a different timezone just because of adding one more century? >> i cannot see an obvious reason. > This thread may be enlightening: > http://archives.postgresql.org/pgsql-patches/2007-

Re: [HACKERS] interval madness ...

2008-06-28 Thread Hans-Juergen Schoenig
On Jun 28, 2008, at 11:39 AM, Gregory Stark wrote: "Hans-Juergen Schoenig" <[EMAIL PROTECTED]> writes: why do i get a different timezone just because of adding one more century? i cannot see an obvious reason. What version of Postgres and what setting of TZ? -- Gregory Stark Enterpr

Re: [HACKERS] interval madness ...

2008-06-28 Thread Gregory Stark
"Hans-Juergen Schoenig" <[EMAIL PROTECTED]> writes: > why do i get a different timezone just because of adding one more century? > i cannot see an obvious reason. This thread may be enlightening: http://archives.postgresql.org/pgsql-patches/2007-09/msg00292.php I can't find the message for the

Re: [HACKERS] interval madness ...

2008-06-28 Thread Gregory Stark
"Hans-Juergen Schoenig" <[EMAIL PROTECTED]> writes: > why do i get a different timezone just because of adding one more century? > i cannot see an obvious reason. What version of Postgres and what setting of TZ? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me ab

[HACKERS] interval madness ...

2008-06-28 Thread Hans-Juergen Schoenig
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() +