Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in functions

Andrey Borodin <x4mmm@yandex-team.ru>

From: Andrey Borodin <x4mmm@yandex-team.ru>

To: Masahiko Sawada <sawada.mshk@gmail.com>

Cc: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>, Jelte Fennema-Nio <postgres@jeltef.nl>, Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2025-10-29T12:19:08Z

Lists: pgsql-hackers

Attachments

v3-0001-Allow-explicit-casting-between-bytea-and-UUID.patch (application/octet-stream)
v3-0003-Add-base32hex-encoding-support-to-encode-and-deco.patch (application/octet-stream)
v3-0002-Minor-suggestions-to-Ilmari-s-patch.patch (application/octet-stream)

> On 28 Oct 2025, at 22:44, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> 
> Andrey has shared his patch for base32hex support before[1]. While it
> needs to be updated, it seems to implement sufficient function.

I'd propose something like attached patch. It's on top of Ilmari's v2 patch with small suggestions as a step 2.

Thanks!

Best regards, Andrey Borodin.