Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3u6l-00GWC7-SX for pgsql-docs@arkaria.postgresql.org; Mon, 06 May 2024 08:54:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s3u6j-00BjfB-88 for pgsql-docs@arkaria.postgresql.org; Mon, 06 May 2024 08:54:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3u6i-00BjeT-4M for pgsql-docs@lists.postgresql.org; Mon, 06 May 2024 08:54:01 +0000 Received: from fhigh5-smtp.messagingengine.com ([103.168.172.156]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3u6d-001gzh-RI for pgsql-docs@lists.postgresql.org; Mon, 06 May 2024 08:53:59 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 5811C1140149; Mon, 6 May 2024 04:53:54 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Mon, 06 May 2024 04:53:54 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1714985634; x= 1715072034; bh=32jJQM73iN/ASA9s4greoxmpP9pWrP0+DHTfDb5hX2w=; b=N dNwKoqziIO/cl765OQEMfryLvMp50uBBpbaJnAzV8ajQHKVRSsJIbrqc+LoMfLQk /7o+GbVuUElxnUJVziPWDO7SvoiQMVQY8/uLBax7xBKAy9MjkJmTECL4rA5bsC2R 7D0DDfIoWLOQ9IVSLoJROFg29e4G6sPHgZ81h9lYjfB6ZTjsNQSMr/Ay9dK15Gf9 /6+wJOY093D3CkEJI1QBA372vaiJD0/taFvCs4JXWWG928w2SI+7NQPKooZ+aS/k rrZvTt3hWvzkmcp32jJag/QxefwJxnbs9R2fE7CNoWx8AFxM+CX5nqBpCcYw5yAs eXN0yOVrBGvJNDAEwAQ8w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvddviedgtdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepueeigfffueektdfgteeuuefgtedvueehgfehleefheel jeelfeffjedttdekvdejnecuffhomhgrihhnpehpohhsthhgrhdrvghspdgvnhhtvghrph hrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 6 May 2024 04:53:53 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1714985631; bh=drUHPcYbXT7ojZa9mW+L9Xb2rS92g1ArJSpSYcooe3A=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=BzMJuT7c9R7fnQPlDciy+h0Vdo+H9LAF1TF2qRYkT7lhuVP55NRDjm76tbuNGcIio vul4eOOFFeh5/fuLn7LvAC/A1lNyE0y8XJRtpftW2BXTl0R1m0rP/RQtTEFRLR54zc Xuet41G7eeMwrJit4KpehPe01BwSaHUdgm5kq8Ra03qhdM8qcAESgPN957C1duE1Ji M77TLUy7kz9gJAmU9H9pt2PIaUMHAgPmnFv3ZTWDsyKDtKjQ3whqgE2d5ltlaZzVAm oD41wevvBA+DJF4OfeGdtVRJeJQ42jT2RlGWVhCTV8mVO3ZG9AeMqpMoNh6vgMdWin vAwxf3MQd3yeg== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id F2289F1; Mon, 6 May 2024 10:53:50 +0200 (CEST) Date: Mon, 6 May 2024 10:53:50 +0200 From: Alvaro Herrera To: David Rowley Cc: Erik Wienhold , Peter Eisentraut , pgsql-docs@lists.postgresql.org Subject: Re: nchar is undocumented Message-ID: <202405060853.t3thj4gr4cpb@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-May-05, David Rowley wrote: > On Sun, 5 May 2024 at 12:41, Erik Wienhold wrote: > > So, I think we should either remove that one nchar instance (because it > > doesn't add any real value) or document it properly. The attached patch > > does the latter. > > It seems easier to do the former, that way we don't need to reconsider > Peter's concerns about not having enough confidence that it matches > the standard. > > I've included Alvaro and Peter to see what they think. Yeah, I too am inclined to remove it. This text was initially written by Mantrova, Bartunov and Glukhov and posted in [1] without further explanation, from where it was copied by Glukhov into [2]; the one I committed is a direct derivate from that. There was no discussion about nchar specifically that I can see, and at least I simply failed to realize that nchar was not something that we talk about. I'll remove it from the list, and backpatch to 16. [1] https://postgr.es/m/732208d3-56c3-25a4-8f08-3be1d54ad51b@postgrespro.ru [2] https://postgr.es/m/8c1ba295-fa42-d4f2-a155-76cf3327d07c@postgrespro.ru % If you, Erik, want to spend some time thinking through the standard definition of NCHAR and whether we conform, perhaps we can document it more fully. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "Java is clearly an example of money oriented programming" (A. Stepanov)