Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lhIdl-0006is-4q for pgsql-docs@arkaria.postgresql.org; Thu, 13 May 2021 21:13:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lhIdj-0001r2-NM for pgsql-docs@arkaria.postgresql.org; Thu, 13 May 2021 21:13:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lhIdj-0001qt-FT for pgsql-docs@lists.postgresql.org; Thu, 13 May 2021 21:13:03 +0000 Received: from mail-pg1-x530.google.com ([2607:f8b0:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lhIdg-0003oN-DA for pgsql-docs@lists.postgresql.org; Thu, 13 May 2021 21:13:02 +0000 Received: by mail-pg1-x530.google.com with SMTP id y32so22531844pga.11 for ; Thu, 13 May 2021 14:12:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=b5I/eGSUZBsSwG2Xn3GKhopFIBSpLHegHwaQUeQ/m7s=; b=jQTVcsoTomREEzAmFD+Cxj8U37j5DVhHzkgtNCXq7odfRbBRfUpT3xi7DqU/FVfrHI FQ3ML8nvytgKsQCtoKAj4AtJ5obnd9OhLOVA5WbkuBIhylUamcZwDMoH2gRsKBPQimYC Uf1TTG76nfGK1afkCUrJD74jcKA5c0V2LkwGCHdYP255gFtq3bWw0UynbS3GkTy4Z1sf GLX8d1H2XVvj17/Ou+FI0bQlG55ZUl9R+wu/HfI73QbaY98mnJOHC/lDlv+m+xeFL1ak dn9m98YAoFKxb024KBea8cQjqj9kxCABxFrXb1SX3E5BRobdQJef5O6bGYQte/oeZRDc CVkw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=b5I/eGSUZBsSwG2Xn3GKhopFIBSpLHegHwaQUeQ/m7s=; b=U3j+e6YPS25hBUgE82EfkTFh+OR1CYKLL5K89KjGy7w/wfF8aHsITCiIOuPkjomO6n BvxIwshFtHWRio0l55AG6KDGcxdz65M3/uWYOthF/BKRuImGo/yDw9pKYStm96K5qxbX tJBv4/4dUNJJb/W22DccB9t01NJFnSA/OpFtY27yKbJOboOTFikR65pU9WKUIprETWe+ 09AxWSgLKRofXgdqZ9sPNp5pVU46/Kk49wflLdaAqyqKwHCWIzyhyqUvqTcFQ5JOkQGb 24cHoY51zubFmQWFcW+vqcijscCHMmIJDDCeOeQZG4F6evA5AvEnoDpDnu4kjuXv7lyK UzMw== X-Gm-Message-State: AOAM533MKmVodp1STEVFm+G1bmWYY5f9Pb7wd/HwAsKMnN9hkHRAIbqd 0mpKoM1yyzHjhiabKxkcfRCk3J7fjTfOycQU/n4= X-Google-Smtp-Source: ABdhPJz/xwzeZ2UOJY9aoq7sfW93HfhXCx6KLIUojIpBsmB2xRnyJp0FvdDqMant0YLCiZ/KG/eypF6BE0vIyKve7+s= X-Received: by 2002:a65:6849:: with SMTP id q9mr21755613pgt.377.1620940378879; Thu, 13 May 2021 14:12:58 -0700 (PDT) MIME-Version: 1.0 References: <88C5909B-A649-4E0C-9037-19CCAED9944A@yugabyte.com> <8A97A8C5-566D-4C4C-9A1F-816A49A64704@yugabyte.com> In-Reply-To: From: "David G. Johnston" Date: Thu, 13 May 2021 14:12:42 -0700 Message-ID: Subject: =?UTF-8?B?UmU6IFdoZXJlIGlzIHRoZSBzeW50YXggIjwtMDg+KzA4IiBkb2N1bWVudGVk4oCUY29tZQ==?= =?UTF-8?B?cyBmcm9tICJzZWxlY3QgY3VycmVudF9zZXR0aW5nKCd0aW1lem9uZScpIg==?= To: Bryn Llewellyn Cc: Pg Docs Content-Type: multipart/alternative; boundary="0000000000007c39bf05c23c979b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007c39bf05c23c979b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, May 13, 2021 at 1:56 PM David G. Johnston < david.g.johnston@gmail.com> wrote: > On Thu, May 13, 2021 at 1:34 PM Bryn Llewellyn wrote: > >> Reading between your lines, the answer to my question =C2=AB Where is th= e >> syntax "<-08>+08" documented? =C2=BB is NOWHERE! The "B.5. POSIX Time Zo= ne >> 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 sing= le >> 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 . 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. --0000000000007c39bf05c23c979b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Reading again I find this:

"In th= is 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>. N= ote that the zone abbreviations given here are only used for output, and ev= en then only in some timestamp output formats."

S= o, the definition of "STD" describes this - it's arguable whe= ther adding the <> to the syntax diagram would be an improvement.

David J.

--0000000000007c39bf05c23c979b--