| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
| Subject: | AT TIME ZONE correction |
| Date: | 2018-09-01 22:55:57 |
| Message-ID: | 20180901225557.GA22406@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
Looking over the AT TIME ZONE docs, I think they are subtly confusing.
The order of conversion specific in the first example should _start_
with the assumption of local time zone for the time stamp, not something
that happens after AT TIME ZONE is applied. The ordering in current
docs makes the second example confusing too.
The attached patch fixes this.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
| Attachment | Content-Type | Size |
|---|---|---|
| time_zone.diff | text/x-diff | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-09-01 23:30:43 | Re: AT TIME ZONE correction |
| Previous Message | Magnus Hagander | 2018-08-30 20:19:28 | Re: Release note trimming: another modest proposal |