Re: Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"
Дата
Msg-id CAKFQuwZDTv_zHChey8th4Vy_gvxdkZNemS1cUVZutp6fwNxgHA@mail.gmail.com
обсуждение исходный текст
Ответ на Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"  (Bryn Llewellyn <bryn@yugabyte.com>)
Ответы Re: Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-docs
Дерево обсуждения
On Thu, May 13, 2021 at 12:38 PM Bryn Llewellyn <bryn@yugabyte.com> wrote:
« POSIX has positive signs west of Greenwich, but many people expect positive signs east of Greenwich. »

Is there a setting that I can do to make "set timezone = '-08:00'" treat it as a request to set the negative value that I said?

That ultimately comes from the appendix.

https://www.postgresql.org/docs/current/datetime-posix-timezone-specs.html

As noted here:

https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-TIMEZONES

There are three ways to specify TimeZone in PostgreSQL.  You are using the third option and thus are dealing with the caveats noted in the third entry's description and described in detail in the appendix linked to above.

I suggest restricting your use to one of the other two, recommended, options.  If you cannot avoid using the third option you must learn and abide by its rules.

David J.

В списке pgsql-docs по дате отправления:

Предыдущее
От: Bryn Llewellyn
Дата:
Сообщение: Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"