MIME-Version: 1.0
References: <1791665551.452444.1761209220211.ref@mail.yahoo.com>
 <1895971769.8343.1761240853939@mail.yahoo.com>
 <CAD21AoCxy_3VW2_z5Rxc-tFsuqeyGsA-F_kD-tx6XXBC56nTCg@mail.gmail.com>
 <574624399.175025.1761290201491@mail.yahoo.com>
 <CAD21AoAXQcZ2mMkxX6NPdFpdC-D3AhE--qyH9Se3XTrDX6x-bg@mail.gmail.com>
 <953203149.383019.1761345585325@mail.yahoo.com>
 <CAD21AoCzEDdwpyPwA0d-QmCRe5rMz3m160SJgxMwKke85e8n0w@mail.gmail.com>
 <6F76FA61-E2DC-44EF-9504-889D9BDB4EBD@yandex-team.ru>
 <CAD21AoCKvYCccndY4CRcwk1bOuWxJionOidEtKQWoJTqS7wL1g@mail.gmail.com>
 <1154454839.957923.1761604611424@mail.yahoo.com>
 <CAGECzQTb9pg2Qw0XmOEKaJivLJ8kdGq3Cq38OqSgwiFVD=9f8A@mail.gmail.com>
 <87ldkv8cog.fsf@wibble.ilmari.org> <87ikfz7zcu.fsf@wibble.ilmari.org>
 <CAD21AoCf-0LdE=Js3ViXmKfSATJOjSNym1+80O+=-Y3X6LDMyA@mail.gmail.com>
 <9CB824CC-70DC-4165-AC6A-9664F47209EE@yandex-team.ru>
 <aa24964a-f0d7-435e-9254-bb69823948d6@gmail.com>
 <CAJ7c6TNCGT2eZ8JttAZKUhVv3jJFTHvjFw6typzSGkM5_vePow@mail.gmail.com>
 <CAD21AoCcikUgU5coyvM7PLJg5M-75LzQhm-Uxmqn_7M=DHkj+w@mail.gmail.com>
 <CAJ7c6TPu7NGrSj-V2-ns0GTNGx9cmoKQgzt-p2MpJepiGjQnYw@mail.gmail.com>
 <CAD21AoC2Ooy=W=4YjQ_GO5nEYZ2tsn43=TkLf7ysE-96ygohKg@mail.gmail.com>
 <878qbn51kb.fsf@wibble.ilmari.org>
 <CAD21AoA7UMWG8YO2Edf1UWSdtaof6gOnF98bJGoz1z1JBzozuQ@mail.gmail.com>
 <CAJ7c6TMd4ebu7oha2C9QZ_aKNE5-keEJ=bE_k_-vrMuw2p1LNg@mail.gmail.com>
 <CAJ7c6TNzQES3EhzoftNUEg=mfi69SYEQ=Fh-=rr84b7zHECHeg@mail.gmail.com>
 <CAD21AoAj+KOc74wOr04oGo9ySYmf_TYkMi5fByLF80cqyZmB=g@mail.gmail.com>
 <1F13AF7E-B90A-40FB-B47C-DC38FBB08353@gmail.com>
 <CAJ7c6TN7fjWDWSVmhQuNCPYLVL9cs9ifc4D_Hj6wUQd2Lw2oNQ@mail.gmail.com>
 <CAD21AoAMST1V1OE=yvg3vQn=p6DDJBAaaFDx39z=P-+Z9iXwOQ@mail.gmail.com>
 <682417.1774482047@sss.pgh.pa.us>
 <431D684B-ABE2-461D-AA26-E009D2630CEA@yandex-team.ru>
 <CAD21AoB2Qe0VYWw_84WH6Zuip1DMNNhLpUu5b+r77CUS3yfmZg@mail.gmail.com>
 <975FB674-1C52-4431-B80F-298075198F25@yandex-team.ru>
In-Reply-To: <975FB674-1C52-4431-B80F-298075198F25@yandex-team.ru>
From: Masahiko Sawada <sawada.mshk@gmail.com>
Date: Thu, 26 Mar 2026 15:01:04 -0700
Message-ID: 
 <CAD21AoDyax67fwjmO3MWh_m5P_5u-x2cEx36M=AJuov_fOTNdw@mail.gmail.com>
Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in
 functions
To: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
 Aleksander Alekseev <aleksander@tigerdata.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>,
 Chao Li <li.evan.chao@gmail.com>,
	=?UTF-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= <ilmari@ilmari.org>
Content-Type: multipart/mixed; boundary="0000000000008c175c064df48783"
Archived-At: 
 <https://www.postgresql.org/message-id/CAD21AoDyax67fwjmO3MWh_m5P_5u-x2cEx36M%3DAJuov_fOTNdw%40mail.gmail.com>
Precedence: bulk

--0000000000008c175c064df48783
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Mar 26, 2026 at 10:59=E2=80=AFAM Andrey Borodin <x4mmm@yandex-team.=
ru> wrote:
>
>
>
> > On 26 Mar 2026, at 22:30, Masahiko Sawada <sawada.mshk@gmail.com> wrote=
:
> >
> >  Feedback is very welcome.
>
> The patch is fine from my POV.
>
> Please consider these small improvements to the patch. Basically, we refe=
rence to formula stated by RFC where possible.
> 0001 is intact.

Thank you for the suggestion. It looks good to me.

I've merged these patches and am going to push barring any objections.

Regards,

--=20
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

--0000000000008c175c064df48783
Content-Type: text/x-patch; charset="US-ASCII";
	name="v2-0001-doc-Clarify-collation-requirements-for-base32hex-.patch"
Content-Disposition: attachment;
	filename="v2-0001-doc-Clarify-collation-requirements-for-base32hex-.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mn80nnyh0>
X-Attachment-Id: f_mn80nnyh0

RnJvbSAzNWQzMjFhOWUzMjE2MDUyYzkxN2I0ZDFhNjFiOTNlY2IxNDE0ZTQyIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBNYXNhaGlrbyBTYXdhZGEgPG1zYXdhZGFAcG9zdGdyZXNxbC5v
cmlnPgpEYXRlOiBUaHUsIDI2IE1hciAyMDI2IDEwOjE3OjIzIC0wNzAwClN1YmplY3Q6IFtQQVRD
SCB2Ml0gZG9jOiBDbGFyaWZ5IGNvbGxhdGlvbiByZXF1aXJlbWVudHMgZm9yIGJhc2UzMmhleAog
c29ydGFiaWxpdHkuCgpXaGlsZSBmaXhpbmcgdGhlIGJhc2UzMmhleCBVVUlEIHNvcnRhYmlsaXR5
IHRlc3QgaW4gY29tbWl0Cjg5MjEwMDM3YTBhLCBpdCB0dXJuZWQgb3V0IHRoYXQgdGhlIGV4cGVj
dGVkIGxleGljb2dyYXBoaWNhbCBvcmRlciBpcwpvbmx5IG1haW50YWluZWQgdW5kZXIgdGhlIEMg
Y29sbGF0aW9uIChvciBhbiBlcXVpdmFsZW50IGJ5dGUtd2lzZQpjb2xsYXRpb24pLiBOYXR1cmFs
IGxhbmd1YWdlIGNvbGxhdGlvbnMgbWF5IGVtcGxveSBkaWZmZXJlbnQgcnVsZXMsCmJyZWFraW5n
IHRoZSBzb3J0YWJpbGl0eS4KClRoaXMgY29tbWl0IHVwZGF0ZXMgdGhlIGRvY3VtZW50YXRpb24g
dG8gZXhwbGljaXRseSBzdGF0ZSB0aGF0CmJhc2UzMmhleCBpcyAiYnl0ZS13aXNlIHNvcnRhYmxl
IiwgZW5zdXJpbmcgdXNlcnMgZG8gbm90IGZhbGwgaW50byB0aGUKdHJhcCBvZiB1c2luZyBuYXR1
cmFsIGxhbmd1YWdlIGNvbGxhdGlvbnMgd2hlbiBxdWVyeWluZyB0aGVpciBlbmNvZGVkCmRhdGEu
CgpDby1BdXRob3JlZC1ieTogTWFzYWhpa28gU2F3YWRhIDxzYXdhZGEubXNoa0BnbWFpbC5jb20+
CkNvLUF1dGhvcmVkLWJ5OiBBbmRyZXkgQm9yb2RpbiA8eDRtbW1AeWFuZGV4LXRlYW0ucnU+CkRp
c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FEMjFBb0F3WDFENmJhU0d1UVhtMG16UFhQ
V0IwN2tnYW9hYWFoak5ISGVuYmRZMjRBQG1haWwuZ21haWwuY29tCi0tLQogZG9jL3NyYy9zZ21s
L2Z1bmMvZnVuYy1iaW5hcnlzdHJpbmcuc2dtbCB8IDE0ICsrKysrKysrKysrLS0tCiAxIGZpbGUg
Y2hhbmdlZCwgMTEgaW5zZXJ0aW9ucygrKSwgMyBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9k
b2Mvc3JjL3NnbWwvZnVuYy9mdW5jLWJpbmFyeXN0cmluZy5zZ21sIGIvZG9jL3NyYy9zZ21sL2Z1
bmMvZnVuYy1iaW5hcnlzdHJpbmcuc2dtbAppbmRleCAwYWFmOWJjNjhmMS4uZGM2YjdlNTdlYTcg
MTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9mdW5jL2Z1bmMtYmluYXJ5c3RyaW5nLnNnbWwKKysr
IGIvZG9jL3NyYy9zZ21sL2Z1bmMvZnVuYy1iaW5hcnlzdHJpbmcuc2dtbApAQCAtNzc4LDE4ICs3
NzgsMjYgQEAKICAgICAgICA8dWxpbmsgdXJsPSJodHRwczovL2RhdGF0cmFja2VyLmlldGYub3Jn
L2RvYy9odG1sL3JmYzQ2NDgjc2VjdGlvbi03Ij4KICAgICAgICBSRkMgNDY0OCBTZWN0aW9uIDc8
L3VsaW5rPi4gIEl0IHVzZXMgdGhlIGV4dGVuZGVkIGhleCBhbHBoYWJldAogICAgICAgICg8bGl0
ZXJhbD4wPC9saXRlcmFsPi08bGl0ZXJhbD45PC9saXRlcmFsPiBhbmQKLSAgICAgICA8bGl0ZXJh
bD5BPC9saXRlcmFsPi08bGl0ZXJhbD5WPC9saXRlcmFsPikgd2hpY2ggcHJlc2VydmVzIHRoZSBs
ZXhpY29ncmFwaGljYWwKLSAgICAgICBzb3J0IG9yZGVyIG9mIHRoZSBlbmNvZGVkIGRhdGEuIFRo
ZSA8ZnVuY3Rpb24+ZW5jb2RlPC9mdW5jdGlvbj4gZnVuY3Rpb24KKyAgICAgICA8bGl0ZXJhbD5B
PC9saXRlcmFsPi08bGl0ZXJhbD5WPC9saXRlcmFsPikgd2hpY2ggcHJlc2VydmVzIHRoZSBzb3J0
IG9yZGVyIG9mCisgICAgICAgdGhlIGVuY29kZWQgZGF0YSB3aGVuIGNvbXBhcmVkIGJ5dGUtd2lz
ZS4gVGhlIDxmdW5jdGlvbj5lbmNvZGU8L2Z1bmN0aW9uPiBmdW5jdGlvbgogICAgICAgIHByb2R1
Y2VzIG91dHB1dCBwYWRkZWQgd2l0aCA8bGl0ZXJhbD4nPSc8L2xpdGVyYWw+LCB3aGlsZSA8ZnVu
Y3Rpb24+ZGVjb2RlPC9mdW5jdGlvbj4KICAgICAgICBhY2NlcHRzIGJvdGggcGFkZGVkIGFuZCB1
bnBhZGRlZCBpbnB1dC4gRGVjb2RpbmcgaXMgY2FzZS1pbnNlbnNpdGl2ZSBhbmQgaWdub3Jlcwog
ICAgICAgIHdoaXRlc3BhY2UgY2hhcmFjdGVycy4KICAgICAgIDwvcGFyYT4KICAgICAgIDxwYXJh
PgotICAgICAgIFRoaXMgZm9ybWF0IGlzIHVzZWZ1bCBmb3IgZW5jb2RpbmcgVVVJRHMgaW4gYSBj
b21wYWN0LCBzb3J0YWJsZSBmb3JtYXQ6CisgICAgICAgVGhpcyBmb3JtYXQgaXMgdXNlZnVsIGZv
ciBlbmNvZGluZyBVVUlEcyBpbiBhIGNvbXBhY3QsIGJ5dGUtd2lzZSBzb3J0YWJsZSBmb3JtYXQ6
CiAgICAgICAgPGxpdGVyYWw+cnRyaW0oZW5jb2RlKHV1aWRfdmFsdWU6OmJ5dGVhLCAnYmFzZTMy
aGV4JyksICc9Jyk8L2xpdGVyYWw+CiAgICAgICAgcHJvZHVjZXMgYSAyNi1jaGFyYWN0ZXIgc3Ry
aW5nIGNvbXBhcmVkIHRvIHRoZSBzdGFuZGFyZCAzNi1jaGFyYWN0ZXIKICAgICAgICBVVUlEIHJl
cHJlc2VudGF0aW9uLgogICAgICAgPC9wYXJhPgorICAgICAgPG5vdGU+CisgICAgICAgPHBhcmE+
CisgICAgICAgIFRvIG1haW50YWluIHRoZSBsZXhpY29ncmFwaGljYWwgc29ydCBvcmRlciBvZiB0
aGUgZW5jb2RlZCBkYXRhLAorICAgICAgICBlbnN1cmUgdGhhdCB0aGUgdGV4dCBpcyBzb3J0ZWQg
dXNpbmcgdGhlIEMgY29sbGF0aW9uCisgICAgICAgIChlLmcuLCB1c2luZyA8bGl0ZXJhbD5DT0xM
QVRFICJDIjwvbGl0ZXJhbD4pLiBOYXR1cmFsIGxhbmd1YWdlCisgICAgICAgIGNvbGxhdGlvbnMg
bWF5IHNvcnQgY2hhcmFjdGVycyBkaWZmZXJlbnRseSBhbmQgYnJlYWsgdGhlIG9yZGVyaW5nLgor
ICAgICAgIDwvcGFyYT4KKyAgICAgIDwvbm90ZT4KICAgICAgPC9saXN0aXRlbT4KICAgICA8L3Zh
cmxpc3RlbnRyeT4KIAotLSAKMi41My4wCgo=
--0000000000008c175c064df48783--