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 1odQMb-00074o-0l for pgsql-docs@arkaria.postgresql.org; Wed, 28 Sep 2022 06:16:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1odQMZ-0002Px-MN for pgsql-docs@arkaria.postgresql.org; Wed, 28 Sep 2022 06:16:07 +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 1odQMZ-0002Pa-6j for pgsql-docs@lists.postgresql.org; Wed, 28 Sep 2022 06:16:07 +0000 Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1odQMS-00039w-Gt for pgsql-docs@lists.postgresql.org; Wed, 28 Sep 2022 06:16:06 +0000 Received: by mail-ej1-x634.google.com with SMTP id l14so24950320eja.7 for ; Tue, 27 Sep 2022 23:16:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:references:in-reply-to:date:to:from:subject :message-id:from:to:cc:subject:date; bh=UzWR/U+GYAs02+62u4jbRtKgnNLehv03JMO6I3X3Jk8=; b=BL6P5AX28R/EvEfHwU8xQuEJVqoFVr2rdfT+DSP4XLB+qKHFs7mE1p+9xJ0wzbHZLz preU4/mvZlOQCDhxzbhjP6iPMFXssHyM/TEimy8gx0XKro/Bh2wGE4vh7h7xBBk2t6rq 7bDxj6lQT7Zg6rKouhWMJpLstpt8LuHj8mNdXNg+cas1wKlAiazrnWKEfkSG9pUl225T 0BeIrhvF2/sMSxVLgTIZo+kiOUgk07sLHkTcjyB3yw0vc5hRszI7wwLY57zKuqkIagNe ab29NsSxUia5Q4OVHg7z+CFJMtgtiin7PCV2mOVCAPVfNKvkW+l32bcWVFkbX4F1qjDF YoTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:references:in-reply-to:date:to:from:subject :message-id:x-gm-message-state:from:to:cc:subject:date; bh=UzWR/U+GYAs02+62u4jbRtKgnNLehv03JMO6I3X3Jk8=; b=sh2jSZS0i8wPfYpeCgSQL/gSsqG4NLkm8cbcr48t8UirtBIm+2C40s0rMPuSI1P9Ta UBJGoM7Owt9jntUJyVjrZoM02qSictb1rIM2zz+sParC3nZAByT2gR3qe/ofQcDVjG7Q B6p97XWd9pvBmXO6FfO2/C2e8H6WmaNknSvGqyO7GvacHpaj18OvvH89xKZis72i+d76 /kbn5woqCIWgKa2CCIbl620sXxHnjioldyGtVCRcn5e2+Lt6dwtNpbyP456vrsKAiB0I QzeCUWR1Nl1b+PpihXmBEFtg6/6St3NgEXXXdbVg3bin7x7/ew5xTKEkvv2pVoRO3Pmq gZBQ== X-Gm-Message-State: ACrzQf0sUyMHZ4BiM7qd7llu+sS2s32ZExZj/zW7czF4FRAOLgEuJzF+ Z8R8HBpZpAR7Bsy1/MeSwEPBNpPg7kZYWg== X-Google-Smtp-Source: AMsMyM6vQreiDhQ7E7IMfUIMKqLTHEUkS+kt1zvoLnDx0vw5kCJwS0QdFXzUZWEBKVtuT2xDb0BWDA== X-Received: by 2002:a17:906:4783:b0:780:5be5:c81b with SMTP id cw3-20020a170906478300b007805be5c81bmr26673504ejc.76.1664345758978; Tue, 27 Sep 2022 23:15:58 -0700 (PDT) Received: from localhost.localdomain (62-46-248-63.adsl.highway.telekom.at. [62.46.248.63]) by smtp.gmail.com with ESMTPSA id u22-20020aa7d556000000b004576e3aee69sm1569146edr.4.2022.09.27.23.15.58 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 27 Sep 2022 23:15:58 -0700 (PDT) Message-ID: Subject: Re: suggest about bpchar data type in the document From: Laurenz Albe To: yanliang lei , "pgsql-docs@lists.postgresql.org" Date: Wed, 28 Sep 2022 08:15:57 +0200 In-Reply-To: <41fe0ea52f9803649ae876d4d14b2b7ca89ffc06.camel@cybertec.at> References: <120b3084.56b6.1833b5ffe4b.Coremail.msdnchina@163.com> <41fe0ea52f9803649ae876d4d14b2b7ca89ffc06.camel@cybertec.at> Content-Type: multipart/mixed; boundary="=-Hj2IJjU2PdMh7MfQMytF" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-Hj2IJjU2PdMh7MfQMytF Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit On Wed, 2022-09-14 at 18:48 +0200, Laurenz Albe wrote: > On Wed, 2022-09-14 at 17:41 +0800, yanliang lei wrote: > > I hope that: > > > >  in the  https://www.postgresql.org/docs/14/datatype-characterin.html ,It needs to be written clearly  “bpchar” data type, > > > > and in the above url, Only mentioned “blank padded” ,If someone does not know  this knowledge point > > (blank padded =bp),he/she  will make a detour in the study of  character datatype。 > > > > so,To make the document more friendly, I suggest that: in the  https://www.postgresql.org/docs/14/datatype-characterin.htm > > It needs to be written clearly  “bpchar” data type。 > > +1 > > I think that adding "bpchar(n)" in table 8.4 would be a good thing. Here is a patch for that. Yours, Laurenz Albe --=-Hj2IJjU2PdMh7MfQMytF Content-Disposition: attachment; filename="0001-Document-bpchar-as-character-data-type.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="0001-Document-bpchar-as-character-data-type.patch"; charset="UTF-8" RnJvbSBmNWNiOTdhOWZmN2Y3ZDBkZjVmOGZlOGE4NDAzYjUyOTg0NjU3ODRlIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogV2VkLCAyOCBTZXAgMjAyMiAwODoxNDoxMSArMDIwMApTdWJqZWN0OiBbUEFUQ0hd IERvY3VtZW50ICJicGNoYXIiIGFzIGNoYXJhY3RlciBkYXRhIHR5cGUKCiJicGNoYXIiIGlzIG91 ciBpbnRlcm5hbCBuYW1lIGZvciAiY2hhcmFjdGVyIiwgYnV0IGl0IHNob3VsZApiZSBkb2N1bWVu dGVkIGFzIGFuIGFsdGVybmF0aXZlIG5hbWUgdG8gYXZvaWQgY29uZnVzaW9uLgoKUGVyIHJlcXVl c3QgZnJvbSBZYW5saWFuZyBMZWkuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzEy MGIzMDg0LjU2YjYuMTgzM2I1ZmZlNGIuQ29yZW1haWwubXNkbmNoaW5hQDE2My5jb20KLS0tCiBk b2Mvc3JjL3NnbWwvZGF0YXR5cGUuc2dtbCB8IDIgKy0KIDEgZmlsZSBjaGFuZ2VkLCAxIGluc2Vy dGlvbigrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9kYXRhdHlw ZS5zZ21sIGIvZG9jL3NyYy9zZ21sL2RhdGF0eXBlLnNnbWwKaW5kZXggMDI1OGIxOTJlMC4uYjg0 NGUzNzliOSAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2RhdGF0eXBlLnNnbWwKKysrIGIvZG9j L3NyYy9zZ21sL2RhdGF0eXBlLnNnbWwKQEAgLTExNjksNyArMTE2OSw3IEBAIFNFTEVDVCAnNTIw OTMuODknOjptb25leTo6bnVtZXJpYzo6ZmxvYXQ4OwogICAgICAgICA8ZW50cnk+dmFyaWFibGUt bGVuZ3RoIHdpdGggbGltaXQ8L2VudHJ5PgogICAgICAgIDwvcm93PgogICAgICAgIDxyb3c+Ci0g ICAgICAgIDxlbnRyeT48dHlwZT5jaGFyYWN0ZXIoPHJlcGxhY2VhYmxlPm48L3JlcGxhY2VhYmxl Pik8L3R5cGU+LCA8dHlwZT5jaGFyKDxyZXBsYWNlYWJsZT5uPC9yZXBsYWNlYWJsZT4pPC90eXBl PjwvZW50cnk+CisgICAgICAgIDxlbnRyeT48dHlwZT5jaGFyYWN0ZXIoPHJlcGxhY2VhYmxlPm48 L3JlcGxhY2VhYmxlPik8L3R5cGU+LCA8dHlwZT5jaGFyKDxyZXBsYWNlYWJsZT5uPC9yZXBsYWNl YWJsZT4pPC90eXBlPiwgPHR5cGU+YnBjaGFyKDxyZXBsYWNlYWJsZT5uPC9yZXBsYWNlYWJsZT4p PC90eXBlPjwvZW50cnk+CiAgICAgICAgIDxlbnRyeT5maXhlZC1sZW5ndGgsIGJsYW5rIHBhZGRl ZDwvZW50cnk+CiAgICAgICAgPC9yb3c+CiAgICAgICAgPHJvdz4KLS0gCjIuMzcuMwoK --=-Hj2IJjU2PdMh7MfQMytF--