Re: timezone() with timeofday() converts the wrong direction?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: postgres-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: timezone() with timeofday() converts the wrong direction?
Date: 2005-04-25 07:05:12
Message-ID: 11426.1114412712@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
> The fact that different versions of PostgreSQL get it right or
> wrong in a variety of ways indicates that the logic may need
> to be fixed but does show that in principle it is quite
> possible.

7.1's version of AT TIME ZONE was so badly broken that it doesn't really
matter whether it accidentally failed to malfunction in your particular
test case. That's simply not relevant to later versions.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephane Bortzmeyer 2005-04-25 07:18:16 Re: Immutable attributes?
Previous Message Karsten Hilbert 2005-04-25 06:28:47 Re: timezone() with timeofday() converts the wrong direction?