On Fri, Dec 25, 2009 at 1:58 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Isn't it the client timezone and not the system timezone that actually
> sets the tz the tstz is set to on retrieval?
It's the GUC:
stark=> set timezone = 'America/Los_Angeles';
SET
stark=> select now();
now
-------------------------------
2009-12-25 06:44:33.238187-08
(1 row)
I'm not sure if and how we initialize the GUC on a new connection
though. It might vary depending on the driver you use too.
--
greg