AFAIK, the input for a timestamptz is converted and stored as UTC.
And outputing a timezonetz value converts the internally stored UTC
value to the current locale's timezone.
So there is not a way to actually store the original TZ itself,
whereas the timetz type clearly does that.
Consider a schema designed to store internet mail.
Since pgsql always converts a timestamptz to UTC, we have lost
the information of the Sender's local timezone.
Should i go with a separete date and timetz ?
--
-Achilleus