public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Bryn Llewellyn <[email protected]>
Cc: Pg Docs <[email protected]>
Subject:  Re: Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"
Date: Thu, 13 May 2021 14:12:42 -0700
Message-ID: <CAKFQuwbnQ4PojgR0HKx5Fd0+v5fw_QeU0_vy0HnMKaL4O=Kd5A@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwYXmmErqOQSfaXbFWADzg7GozxfC3YzrLXgBzJG4SUSJg@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwZDTv_zHChey8th4Vy_gvxdkZNemS1cUVZutp6fwNxgHA@mail.gmail.com>
	<[email protected]>
	<CAKFQuwYXmmErqOQSfaXbFWADzg7GozxfC3YzrLXgBzJG4SUSJg@mail.gmail.com>

On Thu, May 13, 2021 at 1:56 PM David G. Johnston <
[email protected]> wrote:

> On Thu, May 13, 2021 at 1:34 PM Bryn Llewellyn <[email protected]> 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" statement that does in in the POSIX style. And not a single
>> example of what "show timezone" gives after doing a POZIX style setting.
>> (There's no hit for the left- or right-chevron on the page.)
>>
>
> From the appendix:
>
>
Reading again I find this:

"In this syntax, a zone abbreviation can be a string of letters, such as
EST, or an arbitrary string surrounded by angle brackets, such as <UTC-05>.
Note that the zone abbreviations given here are only used for output, and
even then only in some timestamp output formats."

So, the definition of "STD" describes this - it's arguable whether adding
the <> to the syntax diagram would be an improvement.

David J.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re:  Re: Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"
  In-Reply-To: <CAKFQuwbnQ4PojgR0HKx5Fd0+v5fw_QeU0_vy0HnMKaL4O=Kd5A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox