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

Michael Fuhr <mike@fuhr.org> writes:
> The problem I was discussing involves getting *different* time zone
> specifictions in the output.  That is, something like this (which
> apparently is possible in 7.1.3 but not in later versions):

>                f               |           timezone
> -------------------------------+-------------------------------
>  2005-04-24 22:25:51.669218+00 | 2005-04-24 23:25:51.669218+01

It was not really possible in 7.1 either (nor any previous version).
The secret to the above is that in 7.1 the timezone() function's
result is *text*, not a timestamp object.  So it's purely a display
artifact ...

            regards, tom lane