When I store a timestamptz with a non-client timezone,
it is stored in my table converted GMT.
Then, every access to it is in my client timezone, including
extract( timezone from value).
I want to be able to access the timestamps with the
timezone information I input it with.
The way it is puts the burden entirely on the client to figure out
what timezone the data is for and force the appropriate
timezone( 'MST', value) formatting to it for arithmetic and display.
(timzone() requires that we know whether it was day light savings
or not.) Or before and after the query set time zone which
eliminates having to know about day light savings. But
I don't want the whole session to be in the timezone of
the one row of data. I want the timestamp to know its
timezone.
Am I missing something or trying to make it do something
too clever?
thanks for your help,
elein@nextbus.com
--
--------------------------------------------------------
elein@nextbus.com
(510)420-3120
www.nextbus.com
spinning to infinity, hallelujah
--------------------------------------------------------