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

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Sergey Prokhorenko <sergeyprokhorenko(at)yahoo(dot)com(dot)au>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in functions
Date: 2025-10-29 12:19:08
Message-ID: 9CB824CC-70DC-4165-AC6A-9664F47209EE@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 28 Oct 2025, at 22:44, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)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.

Attachment Content-Type Size
v3-0001-Allow-explicit-casting-between-bytea-and-UUID.patch application/octet-stream 4.6 KB
v3-0003-Add-base32hex-encoding-support-to-encode-and-deco.patch application/octet-stream 12.0 KB
v3-0002-Minor-suggestions-to-Ilmari-s-patch.patch application/octet-stream 1.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Jacobson 2025-10-29 12:30:12 Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue
Previous Message Xuneng Zhou 2025-10-29 12:17:47 Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array