emergency.shower@gmail.com wrote:
> If I TIMESTAMP WITH TIME ZONE is implemented on the server as a
> (timestamp, time zone)-pair
It's not, it's just a timestamp in UTC with no timezone stored.
> , the server should be able to cast
> TIMESTAMP WITH TIME ZONE correctly to TIMESTAMP WITHOUT TIME ZONE as
> described in the SQL standard:
>
> From TIMESTAMP WITH TIME ZONE to TIMESTAMP WITHOUT TIME ZONE
> TargetValue = SourceValue.UTC + SourceValue.TimeZone
I'd like to see this too, but Tom doesn't like it for
backwards-compatibility reasons.
-O