Re: Timestamp to time_t

On Sep 15, 2009, at 11:01 AM, Andrew Gierth wrote:

> If you want to store both a timestamp and an associated timezone you
> can do
> it right now, using a composite type or two columns, with the
> advantage that
> you get semantics that you can rely on.

How would a composite work in practice? Can you index it on the
timestamp? Or would you have to use two columns for that?

I could see a real advantage to a type that stored the TZ with which
it was created, with the ability to fetch it back out. Internally the
data could be stored just like it is with timestamptz, and by default,
perhaps, it would display in $PGTZ, but if $PGTZ was set to a value
like "original" or something, it should display the originals. Now
*that* would be really useful IMHO.

Best,

David