In article <20071214.001009.67102034.t-ishii@sraoss.co.jp>,
Tatsuo Ishii <ishii@postgresql.org> wrote:
% From: "Magnus Hagander" <magnus@hagander.net>
[...]
% > > Can I get "+04" without knowing that I inserted the data using "+0400"
% > > time zone?
% > No. The closest you can get is to store the tz in a different column
% and use AT TIMEZONE (which accepts a column name as argument)
% Or use date + time with time zone.
This could cause problems if you want to insert a timestamp for a date
with different DST settings. It also seems a lot more cumbersome to do
it this way.
--
Patrick TJ McPhee
North York Canada
ptjm@interlog.com