Andrew Gierth <and...@tao11.riddles.org.uk> wrote: > If he meant (A), then you store the event as: > (ts,tz) = (timestamp '2010-07-27 10:30:00', > 'Chile/Santiago') > If he meant (B), then you store the event as > (tsz,tz) = (timestamp '2010-07-27 10:30:00' at time zone > 'Chile/Santiago', 'Chile/Santiago') You seem to be agreeing that these problems can't be solved without storing a time zone string in addition to the timestamp. As I read it, HernĂ¡n was wishing for types which include this, rather than having to do the above dance with multiple values. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers