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

On Thu, May 13, 2021 at 1:56 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, May 13, 2021 at 1:34 PM Bryn Llewellyn wrote: > >> Reading between your lines, the answer to my question « Where is the >> syntax "<-08>+08" documented? » is NOWHERE! The "B.5. POSIX Time Zone >>

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

On Thu, May 13, 2021 at 1:34 PM Bryn Llewellyn wrote: > Reading between your lines, the answer to my question « Where is the > syntax "<-08>+08" documented? » is NOWHERE! The "B.5. POSIX Time Zone > Specifications" page that you pointed me to has not a single example of a > "set timezone"

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

> david.g.johns...@gmail.com wrote: > > On Thu, May 13, 2021 at 12:38 PM Bryn Llewellyn > 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 =

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

On Thu, May 13, 2021 at 12:38 PM Bryn Llewellyn 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

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

Summary: Where in the PG docs can I find a self-contained expository essay that explains everything that I need to know in order to understand what's going on in the examples that I show below, and to allow me always confidently to predict the results? Notice that "show datestyle" gives me the