| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | Christophe Pettus <xof(at)thebuild(dot)com>, pgsql-general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PDT but not WEST |
| Date: | 2011-09-29 20:15:21 |
| Message-ID: | 3819.1317327321@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Steve Crawford <scrawford(at)pinpointresearch(dot)com> writes:
> Actually, given that pg_timezone_abbrevs is based on the
> timezone_abbreviations GUC, I'm not surprised that it is a subset of
> what is in pg_timezone_names. But I am a bit surprised that the opposite
> is true.
For zones that observe DST, pg_timezone_names only shows you the active
abbreviation, but pg_timezone_abbrevs includes both summer and winter
abbreviations. Also, there are some zones that have alternate
abbreviations that will never show up in pg_timezone_names
(ZULU and Z for UTC, for instance).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Prashant Bharucha | 2011-09-29 20:19:18 | problem,after restarting server |
| Previous Message | Christophe Pettus | 2011-09-29 19:20:12 | Re: PDT but not WEST |