Feedback-ID: i1ff147bf:Fastmail
From: =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= <ilmari@ilmari.org>
To: Jelte Fennema-Nio <postgres@jeltef.nl>
Cc: Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>,  Andrey Borodin
 <x4mmm@yandex-team.ru>,  Masahiko Sawada <sawada.mshk@gmail.com>,
  pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in
 functions
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>
	<CAD21AoCKvYCccndY4CRcwk1bOuWxJionOidEtKQWoJTqS7wL1g@mail.gmail.com>
	<1154454839.957923.1761604611424@mail.yahoo.com>
	<CAGECzQTb9pg2Qw0XmOEKaJivLJ8kdGq3Cq38OqSgwiFVD=9f8A@mail.gmail.com>
	<87ldkv8cog.fsf@wibble.ilmari.org>
Date: Tue, 28 Oct 2025 16:41:37 +0000
In-Reply-To: <87ldkv8cog.fsf@wibble.ilmari.org> ("Dagfinn Ilmari
 =?utf-8?Q?Manns=C3=A5ker=22's?=
	message of "Tue, 28 Oct 2025 11:53:51 +0000")
Message-ID: <87ikfz7zcu.fsf@wibble.ilmari.org>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.2 (gnu/linux)
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=-=-="
Archived-At: 
 <https://www.postgresql.org/message-id/87ikfz7zcu.fsf%40wibble.ilmari.org>
Precedence: bulk

--=-=-=
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

Dagfinn Ilmari Mannsåker <ilmari@ilmari.org> writes:

> Jelte Fennema-Nio <postgres@jeltef.nl> writes:
>
>> Then combining that with UUID <-> bytea casting (which also
>> seems totally reasonable functionality to me), would give you the
>> functionality (but not the defaults you want).
>
> +1 for adding casts.

Here's a patch for that.  I'm not 100% confident about the error code
for invalid length, but that was the closest one I could find in
errcodes.txt.

I might do the base32hex encode/decode later, unless someone else beats
me to it.

- ilmari


--=-=-=
Content-Type: text/x-diff
Content-Disposition: inline;
 filename=0001-Allow-explicit-casting-between-bytea-and-UUID.patch