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>
In-Reply-To: <431D684B-ABE2-461D-AA26-E009D2630CEA@yandex-team.ru>
From: Masahiko Sawada <sawada.mshk@gmail.com>
Date: Thu, 26 Mar 2026 10:30:21 -0700
Message-ID: 
 <CAD21AoB2Qe0VYWw_84WH6Zuip1DMNNhLpUu5b+r77CUS3yfmZg@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="000000000000727c07064df0bf15"
Archived-At: 
 <https://www.postgresql.org/message-id/CAD21AoB2Qe0VYWw_84WH6Zuip1DMNNhLpUu5b%2Br77CUS3yfmZg%40mail.gmail.com>
Precedence: bulk

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

On Thu, Mar 26, 2026 at 1:32=E2=80=AFAM Andrey Borodin <x4mmm@yandex-team.r=
u> wrote:
>
>
>
> > On 26 Mar 2026, at 04:40, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >
> > I wonder whether this discovery puts enough of a hole in the
> > value-proposition for base32hex that we should just revert
> > this patch altogether.  "It works except in some locales"
> > isn't a very appetizing prospect, so the whole idea is starting
> > to feel more like a foot-gun than a widely-useful feature.
>
> To be precise, this discovery cast shadows on argument "[base32hex is ]le=
xicographically sortable format that preserves temporal ordering for UUIDv7=
". And, actually, any UUID. But I do not think it invalidates the argument =
completely.
>
> It's taken from RFC[0], actually, that states:
>  One property with this alphabet, which the base64 and base32
>  alphabets lack, is that encoded data maintains its sort order when
>  the encoded data is compared bit-wise.
>
>
> RFC does not give any other benefits.
> Personally, I like that it's compact, visually better than base64, and RF=
C-compliant.
> And IMO argument "base32hex is lexicographically sortable format that pre=
serves ordering for UUID in C locale" is still very strong.
> Though, there's a little footy shooty in last 3 words.

Yeah, I still find that base32hex is useful.

As I mentioned in another email, I think we should make a note the
fact that "base32hex is lexicographically sortable format that
preserves ordering for UUID in C locale" in the documentation. I've
attached the patch. Feedback is very welcome.

Regards,

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

--000000000000727c07064df0bf15
Content-Type: text/x-patch; charset="US-ASCII";
	name="v1-0001-doc-Add-note-about-collation-requirements-for-bas.patch"
Content-Disposition: attachment;
	filename="v1-0001-doc-Add-note-about-collation-requirements-for-bas.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mn7qys6e0>
X-Attachment-Id: f_mn7qys6e0

RnJvbSA1MTVjNjY2YjYwZjdmODFmNmIyYTAwNGViZmI5MWIzNTgxODg0NzBjIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBNYXNhaGlrbyBTYXdhZGEgPG1zYXdhZGFAcG9zdGdyZXNxbC5v
cmlnPgpEYXRlOiBUaHUsIDI2IE1hciAyMDI2IDEwOjE3OjIzIC0wNzAwClN1YmplY3Q6IFtQQVRD
SCB2MV0gZG9jOiBBZGQgbm90ZSBhYm91dCBjb2xsYXRpb24gcmVxdWlyZW1lbnRzIGZvciBiYXNl
MzJoZXgKIHNvcnRhYmlsaXR5LgoKV2hpbGUgZml4aW5nIHRoZSBiYXNlMzJoZXggVVVJRCBzb3J0
YWJpbGl0eSB0ZXN0IGluIGNvbW1pdCA4OTIxMDAzN2EwYSwKaXQgdHVybmVkIG91dCB0aGF0IHRo
ZSBleHBlY3RlZCBsZXhpY29ncmFwaGljYWwgb3JkZXIgaXMgb25seSBtYWludGFpbmVkCnVuZGVy
IHRoZSBDIGNvbGxhdGlvbiAob3IgYW4gZXF1aXZhbGVudCBieXRlLXdpc2UgY29sbGF0aW9uKS4K
ClNpbmNlIHRoaXMgaXMgbm90IGp1c3QgYSB0ZXN0aW5nIHF1aXJrIGJ1dCBjb3VsZCBiZSBhIHJl
YWwgdHJhcCB1c2VycwptaWdodCBmYWxsIGludG8gd2hlbiBzb3J0aW5nIGVuY29kZWQgZGF0YSBp
biB0aGVpciBkYXRhYmFzZXMsIHdlIGFkZGVkCmEgbm90ZSB0byB0aGUgZG9jdW1lbnRhdGlvbiB0
byBtYWtlIHRoaXMgcmVxdWlyZW1lbnQgZXhwbGljaXRseSBjbGVhci4KClJldmlld2VkLWJ5OgpE
aXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBRDIxQW9Bd1gxRDZiYVNHdVFYbTBtelBY
UFdCMDdrZ2FvYWFhaGpOSEhlbmJkWTI0QUBtYWlsLmdtYWlsLmNvbQotLS0KIGRvYy9zcmMvc2dt
bC9mdW5jL2Z1bmMtYmluYXJ5c3RyaW5nLnNnbWwgfCA4ICsrKysrKysrCiAxIGZpbGUgY2hhbmdl
ZCwgOCBpbnNlcnRpb25zKCspCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL2Z1bmMvZnVuYy1i
aW5hcnlzdHJpbmcuc2dtbCBiL2RvYy9zcmMvc2dtbC9mdW5jL2Z1bmMtYmluYXJ5c3RyaW5nLnNn
bWwKaW5kZXggMGFhZjliYzY4ZjEuLjlmNzMxZDdiY2EwIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3Nn
bWwvZnVuYy9mdW5jLWJpbmFyeXN0cmluZy5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9mdW5jL2Z1
bmMtYmluYXJ5c3RyaW5nLnNnbWwKQEAgLTc5MCw2ICs3OTAsMTQgQEAKICAgICAgICBwcm9kdWNl
cyBhIDI2LWNoYXJhY3RlciBzdHJpbmcgY29tcGFyZWQgdG8gdGhlIHN0YW5kYXJkIDM2LWNoYXJh
Y3RlcgogICAgICAgIFVVSUQgcmVwcmVzZW50YXRpb24uCiAgICAgICA8L3BhcmE+CisgICAgICA8
bm90ZT4KKyAgICAgICA8cGFyYT4KKyAgICAgICAgVG8gbWFpbnRhaW4gdGhlIGxleGljb2dyYXBo
aWNhbCBzb3J0IG9yZGVyIG9mIHRoZSBlbmNvZGVkIGRhdGEsCisgICAgICAgIGVuc3VyZSB0aGF0
IHRoZSB0ZXh0IGlzIHNvcnRlZCB1c2luZyB0aGUgQyBjb2xsYXRpb24KKyAgICAgICAgKGUuZy4s
IHVzaW5nIDxsaXRlcmFsPkNPTExBVEUgIkMiPC9saXRlcmFsPikuIE5hdHVyYWwgbGFuZ3VhZ2UK
KyAgICAgICAgY29sbGF0aW9ucyBtYXkgc29ydCBjaGFyYWN0ZXJzIGRpZmZlcmVudGx5IGFuZCBi
cmVhayB0aGUgb3JkZXJpbmcuCisgICAgICAgPC9wYXJhPgorICAgICAgPC9ub3RlPgogICAgICA8
L2xpc3RpdGVtPgogICAgIDwvdmFybGlzdGVudHJ5PgogCi0tIAoyLjUzLjAKCg==
--000000000000727c07064df0bf15--