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

Andrey Borodin <x4mmm@yandex-team.ru>

View thread

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

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

Cc: Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2025-10-25T18:07:10Z

Lists: pgsql-hackers

Attachments

v2-0001-Add-uuid_encode-and-uuid_decode-functions.patch (application/octet-stream)

> On 25 Oct 2025, at 04:31, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> 
> Or providing
> 'uuid_encode(uuid, format text) -> text' and 'uuid_decode(text, format
> text) -> uuid' might make sense too, but I'm not sure.

I like the idea, so I drafted a prototype for discussion.
Though I do not see what else methods should be provided along with added one...

Best regards, Andrey Borodin.