Michael Fuhr <mike(at)fuhr(dot)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