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 1p1E0c-00040u-1t for pgsql-committers@arkaria.postgresql.org; Fri, 02 Dec 2022 21:55:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1E0a-0008CJ-Ba for pgsql-committers@arkaria.postgresql.org; Fri, 02 Dec 2022 21:55:48 +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 1p1E0a-0008C9-2g for pgsql-committers@lists.postgresql.org; Fri, 02 Dec 2022 21:55:48 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p1E0W-0008Q0-Qm for pgsql-committers@lists.postgresql.org; Fri, 02 Dec 2022 21:55:47 +0000 Received: by mail-pj1-x102a.google.com with SMTP id u15-20020a17090a3fcf00b002191825cf02so6303019pjm.2 for ; Fri, 02 Dec 2022 13:55:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=zrPsdHugbsMq6gdNDeb9VG03WhYENWwROQ3xKXaYbgs=; b=wJvmsIBuYLwbIAxbu3iRs0MhNh8/v5SsDEY3yESZkzxHKD4lHzPb7eH0x0BgOijbXv PjkglKN7Kw0vu/Yu0f9M0pQz6vxg7QtFAMhdnooSzNgPARhqr3FSBsnmwwz5zzliUkaE FJtSIw8S9DJT6MacP4+xuDtGZVcbHWyOvTTqopWvLzi/hrHUclutVM+Fce/syJeobNOq vabVWs9WryqLQ6NB8WN0v39eHGwOKZmz1BQJOWkIkFsOUxWauH6A7YARm6KD3bHwn3xt ghm9oE2XYCuhNT9wVU4woXd+CeedaUh4sbKnplYbz34Fbce6wx/1l1nxJK81TCQhtZun VBKA== 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:cc:to:from :subject:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=zrPsdHugbsMq6gdNDeb9VG03WhYENWwROQ3xKXaYbgs=; b=JrlHbHJCcveHMdirOf4SvhydIMYYA1buE20KudeCpC7P7qrEXpSsx+zAKwGoRfIwPY DpOtiDgZhVoXXvrX42bXKeRw3sfL9KnhdD1IPeyOxcPCirtWPDMTVncXBHEHDQwUCQOr fvmYLrgvqWEQ3FP8v2SPRJAu3SdHf3xjBSJzlo1BJQmfpOmazCFijjU+dflX7Ntu7kig RbWMk2CA/b+4ph08rXwdVWz8a2gr/ZtJfqfJB7bbdPvI2FTIlHCZK4WygmpA+I1EGDGY TsVH5WRXdPqGjXAGNdnPZoAgqX8AieFqF15YEKqOh98Jc+Uc810TCEB3Y/TVgRIlg5VV IisQ== X-Gm-Message-State: ANoB5pkUmLhdHPmt4Db/Z1BOetyp26FNLngEhUG3pBrHTl9NZh6DBFKj CB8GAnikaT6UoN3ijidg/lqdRA== X-Google-Smtp-Source: AA0mqf4Uq9+vzeBdG7JjausThV6WEB96wkKs9JzBddK+eQFlt1TykGqjLNC5Cw66/ipW+2D9D1iuzg== X-Received: by 2002:a17:903:2350:b0:189:8ea3:7455 with SMTP id c16-20020a170903235000b001898ea37455mr26110400plh.19.1670018142763; Fri, 02 Dec 2022 13:55:42 -0800 (PST) Received: from jeff-laptop.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id e16-20020a17090301d000b00186727e5f5csm6008841plh.248.2022.12.02.13.55.41 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 02 Dec 2022 13:55:42 -0800 (PST) Message-ID: Subject: Re: pgsql: Doc: document bpchar, clarify relationship of text and varchar. From: Jeff Davis To: Tom Lane Cc: pgsql-committers@lists.postgresql.org Date: Fri, 02 Dec 2022 13:55:41 -0800 In-Reply-To: <2129300.1670012806@sss.pgh.pa.us> References: <32a9b8357e8e29b04f395f92c53b64e015a4caf1.camel@j-davis.com> <2129300.1670012806@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="=-p1k6vUWL33EJbn79GDbQ" User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-p1k6vUWL33EJbn79GDbQ Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, 2022-12-02 at 15:26 -0500, Tom Lane wrote: > Perhaps; you got specific wording in mind? Here's what I came up with. It's kind of its own thing, because it can't be described as blank-padded. --=20 Jeff Davis PostgreSQL Contributor Team - AWS --=-p1k6vUWL33EJbn79GDbQ Content-Disposition: attachment; filename="v1-0001-Document-type-BPCHAR-without-length-specifier.patch" Content-Type: text/x-patch; name="v1-0001-Document-type-BPCHAR-without-length-specifier.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSAzZmJlOWMzYTZhY2M5NWQ2N2M0NjhmMTQwNmFiODE2ZDg5YzYwMWJiIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWZmIERhdmlzIDxqZWZmQGotZGF2aXMuY29tPgpEYXRlOiBG cmksIDIgRGVjIDIwMjIgMTM6Mzk6MTMgLTA4MDAKU3ViamVjdDogW1BBVENIIHYxXSBEb2N1bWVu dCB0eXBlIEJQQ0hBUiB3aXRob3V0IGxlbmd0aCBzcGVjaWZpZXIuCgpUaGUgQlBDSEFSIGRhdGF0 eXBlIHdpdGggbm8gbGVuZ3RoIHNwZWNpZmllciBoYXMgaXRzIG93biBzZW1hbnRpY3M7IGl0CmNh bm5vdCBiZSBjb25zaWRlcmVkICJwYWRkZWQiIGFzIGl0IGhhcyBubyBsZW5ndGggdG8gd2hpY2gg aXQgc2hvdWxkCmJlIHBhZGRlZCwgYnV0IHRyYWlsaW5nIHNwYWNlcyBhcmUgc3RpbGwgaWdub3Jl ZC4KLS0tCiBkb2Mvc3JjL3NnbWwvZGF0YXR5cGUuc2dtbCB8IDMxICsrKysrKysrKysrKysrKysr KystLS0tLS0tLS0tLS0KIDEgZmlsZSBjaGFuZ2VkLCAxOSBpbnNlcnRpb25zKCspLCAxMiBkZWxl dGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvZGF0YXR5cGUuc2dtbCBiL2RvYy9z cmMvc2dtbC9kYXRhdHlwZS5zZ21sCmluZGV4IGZkZmZiYTQ0NDIuLjgyNGUyYTMwMjIgMTAwNjQ0 Ci0tLSBhL2RvYy9zcmMvc2dtbC9kYXRhdHlwZS5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9kYXRh dHlwZS5zZ21sCkBAIC0xMTc0LDcgKzExNzQsMTEgQEAgU0VMRUNUICc1MjA5My44OSc6Om1vbmV5 OjpudW1lcmljOjpmbG9hdDg7CiAgICAgICAgPC9yb3c+CiAgICAgICAgPHJvdz4KICAgICAgICAg PGVudHJ5Pjx0eXBlPmNoYXJhY3Rlcig8cmVwbGFjZWFibGU+bjwvcmVwbGFjZWFibGU+KTwvdHlw ZT4sIDx0eXBlPmNoYXIoPHJlcGxhY2VhYmxlPm48L3JlcGxhY2VhYmxlPik8L3R5cGU+LCA8dHlw ZT5icGNoYXIoPHJlcGxhY2VhYmxlPm48L3JlcGxhY2VhYmxlPik8L3R5cGU+PC9lbnRyeT4KLSAg ICAgICAgPGVudHJ5PmZpeGVkLWxlbmd0aCwgYmxhbmsgcGFkZGVkPC9lbnRyeT4KKyAgICAgICAg PGVudHJ5PmZpeGVkLWxlbmd0aCwgYmxhbmstcGFkZGVkPC9lbnRyeT4KKyAgICAgICA8L3Jvdz4K KyAgICAgICA8cm93PgorICAgICAgICA8ZW50cnk+PHR5cGU+YnBjaGFyPC90eXBlPjwvZW50cnk+ CisgICAgICAgIDxlbnRyeT52YXJpYWJsZSB1bmxpbWl0ZWQgbGVuZ3RoLCBibGFuay10cmltbWVk PC9lbnRyeT4KICAgICAgICA8L3Jvdz4KICAgICAgICA8cm93PgogICAgICAgICA8ZW50cnk+PHR5 cGU+dGV4dDwvdHlwZT48L2VudHJ5PgpAQCAtMTIzMCwyMCArMTIzNCwyMyBAQCBTRUxFQ1QgJzUy MDkzLjg5Jzo6bW9uZXk6Om51bWVyaWM6OmZsb2F0ODsKIAogICAgPHBhcmE+CiAgICAgVGhlIHR5 cGUgbmFtZSA8dHlwZT52YXJjaGFyPC90eXBlPiBpcyBhbiBhbGlhcyBmb3IgPHR5cGU+Y2hhcmFj dGVyCi0gICAgdmFyeWluZzwvdHlwZT4sIHdoaWxlIDx0eXBlPmNoYXI8L3R5cGU+IGFuZCA8dHlw ZT5icGNoYXI8L3R5cGU+IGFyZQotICAgIGFsaWFzZXMgZm9yIDx0eXBlPmNoYXJhY3RlcjwvdHlw ZT4uCi0gICAgVGhlIDx0eXBlPnZhcmNoYXI8L3R5cGU+IGFuZCA8dHlwZT5jaGFyPC90eXBlPiBh bGlhc2VzIGFyZSBkZWZpbmVkIGluCi0gICAgdGhlIDxhY3JvbnltPlNRTDwvYWNyb255bT4gc3Rh bmRhcmQsIGJ1dCA8dHlwZT5icGNoYXI8L3R5cGU+IGlzCi0gICAgYSA8cHJvZHVjdG5hbWU+UG9z dGdyZVNRTDwvcHJvZHVjdG5hbWU+IGV4dGVuc2lvbi4KKyAgICB2YXJ5aW5nPC90eXBlPiwgd2hp bGUgPHR5cGU+YnBjaGFyPC90eXBlPiAod2l0aCBsZW5ndGggc3BlY2lmaWVyKSBhbmQKKyAgICA8 dHlwZT5jaGFyPC90eXBlPiBhcmUgYWxpYXNlcyBmb3IgPHR5cGU+Y2hhcmFjdGVyPC90eXBlPi4g IFRoZQorICAgIDx0eXBlPnZhcmNoYXI8L3R5cGU+IGFuZCA8dHlwZT5jaGFyPC90eXBlPiBhbGlh c2VzIGFyZSBkZWZpbmVkIGluIHRoZQorICAgIDxhY3JvbnltPlNRTDwvYWNyb255bT4gc3RhbmRh cmQsIGJ1dCA8dHlwZT5icGNoYXI8L3R5cGU+IGlzIGEKKyAgICA8cHJvZHVjdG5hbWU+UG9zdGdy ZVNRTDwvcHJvZHVjdG5hbWU+IGV4dGVuc2lvbi4KICAgIDwvcGFyYT4KIAogICAgPHBhcmE+Ci0g ICAgSWYgc3BlY2lmaWVkLCB0aGUgbGVuZ3RoIDxyZXBsYWNlYWJsZT5uPC9yZXBsYWNlYWJsZT4g bXVzdCBiZSBncmVhdGVyCi0gICAgdGhhbiB6ZXJvIGFuZCBjYW5ub3QgZXhjZWVkIDEwNDg1NzYw LgotICAgIDx0eXBlPmNoYXJhY3RlcjwvdHlwZT4gd2l0aG91dCBsZW5ndGggc3BlY2lmaWVyIGlz IGVxdWl2YWxlbnQgdG8KLSAgICA8dHlwZT5jaGFyYWN0ZXIoMSk8L3R5cGU+LiBJZiA8dHlwZT5j aGFyYWN0ZXIgdmFyeWluZzwvdHlwZT4gaXMgdXNlZAotICAgIHdpdGhvdXQgbGVuZ3RoIHNwZWNp ZmllciwgdGhlIHR5cGUgYWNjZXB0cyBzdHJpbmdzIG9mIGFueSBzaXplLiBUaGUKLSAgICBsYXR0 ZXIgYmVoYXZpb3IgaXMgYSA8cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwvcHJvZHVjdG5hbWU+IGV4 dGVuc2lvbi4KKyAgICBJZiBzcGVjaWZpZWQsIHRoZSBsZW5ndGggPHJlcGxhY2VhYmxlPm48L3Jl cGxhY2VhYmxlPiBtdXN0IGJlIGdyZWF0ZXIgdGhhbgorICAgIHplcm8gYW5kIGNhbm5vdCBleGNl ZWQgMTA0ODU3NjAuICA8dHlwZT5jaGFyYWN0ZXI8L3R5cGU+IG9yCisgICAgPHR5cGU+Y2hhcjwv dHlwZT4gd2l0aG91dCBsZW5ndGggc3BlY2lmaWVyIGFyZSBlcXVpdmFsZW50IHRvCisgICAgPHR5 cGU+Y2hhcmFjdGVyKDEpPC90eXBlPi4gSWYgPHR5cGU+Y2hhcmFjdGVyIHZhcnlpbmc8L3R5cGU+ IG9yCisgICAgPHR5cGU+dmFyY2hhcjwvdHlwZT4gYXJlIHVzZWQgd2l0aG91dCBsZW5ndGggc3Bl Y2lmaWVyLCB0aGUgdHlwZSBhY2NlcHRzCisgICAgc3RyaW5ncyBvZiBhbnkgc2l6ZS4gVGhlIGxh dHRlciBiZWhhdmlvciBpcyBhCisgICAgPHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8L3Byb2R1Y3Ru YW1lPiBleHRlbnNpb24uIElmIDx0eXBlPmJwY2hhcjwvdHlwZT4gaXMKKyAgICB1c2VkIHdpdGhv dXQgbGVuZ3RoIHNwZWNpZmllciwgaXQgYWNjZXB0cyBzdHJpbmdzIG9mIGFueSBzaXplLCBidXQK KyAgICB0cmFpbGluZyBzcGFjZXMgYXJlIHNlbWFudGljYWxseSBpbnNpZ25pZmljYW50LgogICAg PC9wYXJhPgogCiAgICA8cGFyYT4KLS0gCjIuMzQuMQoK --=-p1k6vUWL33EJbn79GDbQ--