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: 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-25 18:07:10
Message-ID: 6F76FA61-E2DC-44EF-9504-889D9BDB4EBD@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 25 Oct 2025, at 04:31, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)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.

Attachment Content-Type Size
v2-0001-Add-uuid_encode-and-uuid_decode-functions.patch application/octet-stream 17.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Jones 2025-10-25 18:48:34 Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Previous Message Joel Jacobson 2025-10-25 18:01:56 Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue