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 <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1oTY3s-0001gk-09
	for pgsql-docs@arkaria.postgresql.org; Thu, 01 Sep 2022 00:28:00 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1oTY3q-0007PH-AJ
	for pgsql-docs@arkaria.postgresql.org; Thu, 01 Sep 2022 00:27:58 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1oTY3q-0007P0-2e
	for pgsql-docs@lists.postgresql.org; Thu, 01 Sep 2022 00:27:58 +0000
Received: from momjian.us ([72.94.173.45])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1oTY3n-0001R6-Pe
	for pgsql-docs@lists.postgresql.org; Thu, 01 Sep 2022 00:27:57 +0000
Received: from bruce by momjian.us with local (Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1oTY3l-004bx0-Q0; Wed, 31 Aug 2022 20:27:53 -0400
Date: Wed, 31 Aug 2022 20:27:53 -0400
From: Bruce Momjian <bruce@momjian.us>
To: philippe.godfrin@nov.com, pgsql-docs@lists.postgresql.org
Subject: Re: set time zone
Message-ID: <Yw/8icWRANGdovOT@momjian.us>
References: <163888728952.1269.5167822676466793158@wrigleys.postgresql.org>
 <Yvw5IaULlSZ97PCt@momjian.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Yvw5IaULlSZ97PCt@momjian.us>
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/Yw/8icWRANGdovOT%40momjian.us>
Precedence: bulk

On Tue, Aug 16, 2022 at 08:41:05PM -0400, Bruce Momjian wrote:
> On Tue, Dec  7, 2021 at 02:28:09PM +0000, PG Doc comments form wrote:
> > TIME ZONE
> > SET TIME ZONE timezone_name is an alias for SET timezone TO timezone_name.
> 
> I ended up changing the syntax from 'timezone' to 'value' and added
> quoted and non-quoted syntax options, again in the attached patch.

Patch applied back to PG 10.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson