"Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> writes:
> I have two functions that have a timestamp wtz passed to and return
> timestamps wtz in a refcursor. The catch is that I need the timezone on the
> timestamp passed out to match the timezone of the timestamp passed in.
You're misunderstanding how timestamp with time zone works. There isn't
any explicitly stored zone in a timestamptz value --- it's all GMT under
the hood. A zone is only introduced for display.
regards, tom lane