Re: timezone() with timeofday() converts the wrong direction? - Mailing list pgsql-general

From Tom Lane
Subject Re: timezone() with timeofday() converts the wrong direction?
Date
Msg-id 11426.1114412712@sss.pgh.pa.us
Whole thread Raw
In response to Re: timezone() with timeofday() converts the wrong direction?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: timezone() with timeofday() converts the wrong direction?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Karsten Hilbert <Karsten.Hilbert@gmx.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

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: timezone() with timeofday() converts the wrong direction?
Next
From: Stephane Bortzmeyer
Date:
Subject: Re: Immutable attributes?