Re: The contents of the pg_timezone_names view bring some surprises

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Bryn Llewellyn <bryn(at)yugabyte(dot)com>
Cc: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: The contents of the pg_timezone_names view bring some surprises
Date: 2021-05-19 07:03:22
Message-ID: CAKFQuwaUrh4cEJc8AJkXsgxWebJPPcrtqkZ0JT__yLsy4ys1hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, May 18, 2021, Bryn Llewellyn <bryn(at)yugabyte(dot)com> wrote:

> Some time zones have abbreviations that are identical to their names. This
> query:
>
> Am I missing an essential clue to resolving what seems to me to be a
> paradox? Or am I seeing two kinds of bug?
>
>
You are missing the material in appendix B.4

https://www.postgresql.org/docs/current/datetime-config-files.html

I think that covers dealing with the situations you note.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MEERA 2021-05-19 08:24:00 Plan for exclusive backup method
Previous Message Bryn Llewellyn 2021-05-19 06:31:57 The contents of the pg_timezone_names view bring some surprises