Re: Timestamp with vs without time zone. - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Timestamp with vs without time zone.
Date
Msg-id 6fecaaa93b51b57cd8dd52312a25db79a337bd4b.camel@cybertec.at
Whole thread Raw
In response to Re: Timestamp with vs without time zone.  (Tim Uckun <timuckun@gmail.com>)
Responses Aw: Re: Timestamp with vs without time zone.
List pgsql-general
On Tue, 2021-09-21 at 19:35 +1200, Tim Uckun wrote:
> It seems like it would be so much more useful if the timestamp with
> time zone type actually stored the time zone in the record.

This has been requested before, and it would be closer to the intention
of the SQL standard, but I guess it won't happen.

For one, it would change on-disk storage, which would make it
impossible to use pg_upgrade.  It also would require timestamps to
occupy more than 8 bytes.

The best solution is probably to explicitly store the time zone as
an additional column.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper
Next
From: Karsten Hilbert
Date:
Subject: Aw: Re: Timestamp with vs without time zone.