| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Tim Uckun <timuckun(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Timestamp with vs without time zone. |
| Date: | 2021-09-21 07:39:34 |
| Message-ID: | 6fecaaa93b51b57cd8dd52312a25db79a337bd4b.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2021-09-21 07:39:59 | Aw: Re: Timestamp with vs without time zone. |
| Previous Message | Laurenz Albe | 2021-09-21 07:35:47 | Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper |