Date: Sat, 25 Oct 2025 19:15:48 +0000 (UTC)
From: Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
To: Masahiko Sawada <sawada.mshk@gmail.com>,
	Andrey Borodin <x4mmm@yandex-team.ru>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Message-ID: <1522684793.499678.1761419748726@mail.yahoo.com>
In-Reply-To: <6F76FA61-E2DC-44EF-9504-889D9BDB4EBD@yandex-team.ru>
References: <1791665551.452444.1761209220211.ref@mail.yahoo.com>
 <1791665551.452444.1761209220211@mail.yahoo.com>
 <CAJ7c6TOramr1UTLcyB128LWMqita1Y7=arq3KHaU=qikf5yKOQ@mail.gmail.com>
 <18022523-0F8F-4C07-AFF5-57DC9086D78E@yandex-team.ru>
 <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>
Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in
 functions
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_499677_1214463112.1761419748724"
Content-Length: 4238
Archived-At: 
 <https://www.postgresql.org/message-id/1522684793.499678.1761419748726%40mail.yahoo.com>
Precedence: bulk

------=_Part_499677_1214463112.1761419748724
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

> On 25 Oct 2025, at 04:31, Masahiko Sawada <sawada.mshk@gmail.com> wrote:>=
=20
> Or providing
> 'uuid_encode(uuid, format text) -> text' and 'uuid_decode(text, format
> text) -> uuid' might make sense too, but I'm not sure.
>=C2=A0On Saturday 25 October 2025 at 09:07:39 pm GMT+3, Andrey Borodin <x4=
mmm@yandex-team.ru> wrote:
>=C2=A0I like the idea, so I drafted a prototype for discussion.
>=C2=A0Though I do not see what else methods should be provided along with =
added one...


>=C2=A0Best regards, Andrey Borodin.

If base32hex becomes the default string=C2=A0representation=C2=A0for UUIDs =
in PostgreSQL, then the=C2=A0canonical UUID string representation=C2=A0may =
be added into these functions for backward compatibility.
Best regards,
Sergey Prokhorenko


 =20
------=_Part_499677_1214463112.1761419748724
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydp729bd840yahoo-style-wrap" style=
=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px=
;"><div dir=3D"ltr" data-setdir=3D"false"><span style=3D"color: rgb(38, 40,=
 42); font-size: 13px;">&gt; On 25 Oct 2025, at 04:31, Masahiko Sawada &lt;=
</span><a shape=3D"rect" href=3D"mailto:sawada.mshk@gmail.com" rel=3D"nofol=
low" target=3D"_blank" style=3D"font-size: 13px;">sawada.mshk@gmail.com</a>=
<span style=3D"color: rgb(38, 40, 42); font-size: 13px;">&gt; wrote:</span>=
</div></div><div id=3D"ydp3cd4dcd5yahoo_quoted_2152815530" class=3D"ydp3cd4=
dcd5yahoo_quoted"><div style=3D"font-family:'Helvetica Neue', Helvetica, Ar=
ial, sans-serif;font-size:13px;color:#26282a;"><div><div dir=3D"ltr" data-s=
etdir=3D"false"><div class=3D"ydp3cd4dcd5yqt7247827545" id=3D"ydp3cd4dcd5yq=
tfd85220">&gt; <br clear=3D"none">&gt; Or providing<br clear=3D"none">&gt; =
'uuid_encode(uuid, format text) -&gt; text' and 'uuid_decode(text, format<b=
r clear=3D"none">&gt; text) -&gt; uuid' might make sense too, but I'm not s=
ure.</div><br clear=3D"none"><span><span style=3D"color: rgb(38, 40, 42); f=
ont-family: Helvetica Neue, Helvetica, Arial, sans-serif;">&gt;&nbsp;</span=
><span style=3D"color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvet=
ica, Arial, sans-serif;">On Saturday 25 October 2025 at 09:07:39 pm GMT+3, =
Andrey Borodin &lt;x4mmm@yandex-team.ru&gt; wrote:</span></span><br clear=
=3D"none"><span><span style=3D"color: rgb(38, 40, 42); font-family: Helveti=
ca Neue, Helvetica, Arial, sans-serif;">&gt;&nbsp;</span></span>I like the =
idea, so I drafted a prototype for discussion.<br clear=3D"none"><span><spa=
n style=3D"color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvetica, =
Arial, sans-serif;">&gt;&nbsp;</span></span>Though I do not see what else m=
ethods should be provided along with added one...<br clear=3D"none"><br cle=
ar=3D"none"><br clear=3D"none"><span><span style=3D"color: rgb(38, 40, 42);=
 font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">&gt;&nbsp;</sp=
an></span>Best regards, Andrey Borodin.</div><div dir=3D"ltr" data-setdir=
=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div =
dir=3D"ltr" data-setdir=3D"false"><span>If base32hex becomes the default <s=
pan><span style=3D"color: rgb(38, 40, 42); font-family: Helvetica Neue, Hel=
vetica, Arial, sans-serif;">string&nbsp;</span></span><span>representation&=
nbsp;</span>for UUIDs in PostgreSQL, then the&nbsp;<span>canonical <span>UU=
ID string representation</span>&nbsp;</span>may be added into these functio=
ns for backward compatibility.</span></div><div dir=3D"ltr" data-setdir=3D"=
false"><span><br></span><span><span style=3D"color: rgb(38, 40, 42); font-f=
amily: Helvetica Neue, Helvetica, Arial, sans-serif;">Best regards,<br></sp=
an></span>Sergey Prokhorenko<br><br></div><div dir=3D"ltr" data-setdir=3D"f=
alse"><br></div><div dir=3D"ltr" data-setdir=3D"false"><br><br><br><br><div=
 class=3D"ydp3cd4dcd5yqt7247827545" id=3D"ydp3cd4dcd5yqtfd08994"><br clear=
=3D"none"></div></div></div>
            </div>
        </div></body></html>
------=_Part_499677_1214463112.1761419748724--