Andrew Gierth <andrew@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
