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 1p1CcW-0006b1-LF for pgsql-committers@arkaria.postgresql.org; Fri, 02 Dec 2022 20:26:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1CcV-0005kV-6v for pgsql-committers@arkaria.postgresql.org; Fri, 02 Dec 2022 20:26:51 +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 ) id 1p1CcV-0005kM-0G for pgsql-committers@lists.postgresql.org; Fri, 02 Dec 2022 20:26:51 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1CcS-0006dI-Vh for pgsql-committers@lists.postgresql.org; Fri, 02 Dec 2022 20:26:50 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 2B2KQkxq2129301; Fri, 2 Dec 2022 15:26:46 -0500 From: Tom Lane To: Jeff Davis cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Doc: document bpchar, clarify relationship of text and varchar. In-reply-to: <32a9b8357e8e29b04f395f92c53b64e015a4caf1.camel@j-davis.com> References: <32a9b8357e8e29b04f395f92c53b64e015a4caf1.camel@j-davis.com> Comments: In-reply-to Jeff Davis message dated "Fri, 02 Dec 2022 12:18:22 -0800" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2129299.1670012806.1@sss.pgh.pa.us> Date: Fri, 02 Dec 2022 15:26:46 -0500 Message-ID: <2129300.1670012806@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Jeff Davis writes: > BPCHAR is documented as an alias to CHARACTER, but the former can end > up with no typmod at all whereas the latter defaults to CHARACTER(1). > Should we document the case of using BPCHAR with no length? Perhaps; you got specific wording in mind? (I think that that difference is in fact documented somewhere, but maybe not where you looked.) regards, tom lane