MIME-Version: 1.0
References: <1791665551.452444.1761209220211.ref@mail.yahoo.com>
 <1791665551.452444.1761209220211@mail.yahoo.com>
 <CAJ7c6TOramr1UTLcyB128LWMqita1Y7=arq3KHaU=qikf5yKOQ@mail.gmail.com>
In-Reply-To: 
 <CAJ7c6TOramr1UTLcyB128LWMqita1Y7=arq3KHaU=qikf5yKOQ@mail.gmail.com>
From: Aleksander Alekseev <aleksander@tigerdata.com>
Date: Thu, 23 Oct 2025 18:08:29 +0300
Message-ID: 
 <CAJ7c6TNOWMOsUPDHHDs=D-0T_c2XxDuTcrD7XwFNuz3JM6AOOA@mail.gmail.com>
Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in
 functions
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>
Content-Type: multipart/mixed; boundary="000000000000f740180641d4ce13"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJ7c6TNOWMOsUPDHHDs%3DD-0T_c2XxDuTcrD7XwFNuz3JM6AOOA%40mail.gmail.com>
Precedence: bulk

--000000000000f740180641d4ce13
Content-Type: text/plain; charset="UTF-8"

Hi,

> > I'm writing to propose adding two new built-in functions to PostgreSQL that provide compact UUID encoding using the base32hex format.
>
> Firstly, cc:'ing a few dozens of people is not the best way to get
> attention to your patch. Please don't do this.
>
> [...]

I checked pgsql-hackers@ archive [1] and if I understand correctly
Sergey is not on the mailing list. So people that were not cc:'ed
didn't receive his e-mail. I attached the original text for those
interested and also for history.

Sergey, please make sure you are subscribed to the mailing list [2].

[1]: https://www.postgresql.org/message-id/CAJ7c6TOramr1UTLcyB128LWMqita1Y7%3Darq3KHaU%3Dqikf5yKOQ%40mail.gmail.com
[2]: https://www.postgresql.org/list/

-- 
Best regards,
Aleksander Alekseev

--000000000000f740180641d4ce13
Content-Type: text/plain; charset="US-ASCII"; name="hi-hackers.txt"
Content-Disposition: attachment; filename="hi-hackers.txt"
Content-Transfer-Encoding: base64
Content-ID: <f_mh3k1hnw0>
X-Attachment-Id: f_mh3k1hnw0

SGkgcGdzcWwtaGFja2VycywKCkknbSB3cml0aW5nIHRvIHByb3Bvc2UgYWRkaW5nIHR3byBuZXcg
YnVpbHQtaW4gZnVuY3Rpb25zIHRvIFBvc3RncmVTUUwgdGhhdCBwcm92aWRlIGNvbXBhY3QgVVVJ
RCBlbmNvZGluZyB1c2luZyB0aGUgYmFzZTMyaGV4IGZvcm1hdC4KCkknbSBvbmUgb2YgdGhlIGNv
bnRyaWJ1dG9ycyB0byBSRkMgOTU2MiAoVVVJRHMpIGFuZCB0byB0aGUgdXVpZHY3KCkgaW1wbGVt
ZW50YXRpb25zIGluIFBvc3RncmVTUUwgYW5kIHNldmVyYWwgbGlicmFyaWVzLiBJJ20gd3JpdGlu
ZyB0byBleHByZXNzIG15IHN0cm9uZyBzdXBwb3J0IGZvciBhIG5ldyBwYXRjaCBieSBBbmRyZXkg
Qm9yb2RpbiwgdGhlIGRldmVsb3BlciBvZiB0aGUgYnVpbHQtaW4gdXVpZHY3KCkgZnVuY3Rpb24g
Zm9yIFBvc3RncmVTUUwgMTguIFRoaXMgcGF0Y2ggYWRkcyB0d28gbmV3IGZ1bmN0aW9ucyBmb3Ig
VVVJRCBjb21wYWN0IHRleHQgcmVwcmVzZW50YXRpb24uIFRoZXNlIGZ1bmN0aW9ucyB3b3VsZCBi
ZSBsb25nLWF3YWl0ZWQgYWRkaXRpb25zIHRvIFBvc3RncmVTUUwncyBVVUlEIGZ1bmN0aW9uYWxp
dHkuCgpJIHdvdWxkIGxpa2UgdG8gcmVxdWVzdCB0aGUgY29tbXVuaXR5IHRvIHJldmlldyB0aGlz
IHBhdGNoIGFuZCB0byBjb25zaWRlciBpdCBmb3IgY29tbWl0LgoKVGhlIHBhdGNoIGlzIGF2YWls
YWJsZSBoZXJlOiBodHRwczovL2dpdGh1Yi5jb20veDRtL3Bvc3RncmVzX2cvY29tbWl0L2FhOTAy
YmJjNWRmYzQ3ZDRiMzVmMDUwMTYzMDRhMWU2NzFhYmI1MDUgCgpfX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fCgp1dWlkX3RvX2Jhc2UzMmhleCAoIHV1aWQgKSAtPiB0ZXh0CgpFbmNvZGVz
IGEgVVVJRCBpbnRvIGEgMjYtY2hhcmFjdGVyIGJhc2UzMmhleCBzdHJpbmcgKHVwcGVyY2FzZSwg
bm8gaHlwaGVucywgd2l0aG91dCBwYWRkaW5nKSwgdXNpbmcgdGhlIGFscGhhYmV0IDAxMjM0NTY3
ODlBQkNERUZHSElKS0xNTk9QUVJTVFVWIGFzIHNwZWNpZmllZCBpbiBSRkMgNDY0OCAoaHR0cHM6
Ly9kYXRhdHJhY2tlci5pZXRmLm9yZy9kb2MvaHRtbC9yZmM0NjQ4I3BhZ2UtMTApLgoKVG8gYWNj
b21tb2RhdGUgYmFzZTMyaGV4IGVuY29kaW5nICg1IGJpdHMgcGVyIGNoYXJhY3RlciksIHRoZSAx
MjgtYml0IFVVSUQgcmVxdWlyZXMgMTMwIGJpdHMgdG90YWwgKDI2IGNoYXJhY3RlcnMgPyA1IGJp
dHMpLiBUaGUgYWRkaXRpb25hbCAyIHplcm8gYml0cyBhcmUgYXBwZW5kZWQgYXMgcGFkZGluZy4K
ClRoaXMgY29tcGFjdCwgbGV4aWNvZ3JhcGhpY2FsbHkgc29ydGFibGUgZm9ybWF0IHByZXNlcnZl
cyB0ZW1wb3JhbCBvcmRlcmluZyBmb3IgVVVJRHY3LCBtYWtpbmcgaXQgaWRlYWwgZm9yIHByaW1h
cnkga2V5cyBzdG9yZWQgYXMgdmFsdWVzIGluIEpTT04ga2V5LXZhbHVlIHBhaXJzLCBhcyB3ZWxs
IGFzIGZvciBVUkxzLCBmaWxlbmFtZXMsIGFuZCBvdGhlciBzcGFjZS1jb25zdHJhaW5lZCBjb250
ZXh0cy4KCkV4YW1wbGU6CnV1aWRfdG9fYmFzZTMyaGV4KCcwMTk1MzVkOS0zZGY3LTc5ZmItYjQ2
Ni1mYTkwN2ZhMTdmOWUnOjp1dWlkKSA+IDA2QUpCTTlUVVRTVk5EMzZWQTg3VjhCVkpPCl9fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX18KCmJhc2UzMmhleF90b191dWlkICggdGV4dCApIC0+
IHV1aWQKCkRlY29kZXMgYSBiYXNlMzJoZXggc3RyaW5nIGJhY2sgaW50byBpdHMgb3JpZ2luYWwg
VVVJRC4gVGhlIGlucHV0IGlzIGNhc2UtaW5zZW5zaXRpdmUuIEludmFsaWQgaW5wdXRzIHJldHVy
biBOVUxMLiBUaGUgZGVjb2RpbmcgaXMgbG9zc2xlc3MgYW5kIHByb2R1Y2VzIGEgYml0d2lzZS1p
ZGVudGljYWwgVVVJRC4KCkV4YW1wbGU6CmJhc2UzMmhleF90b191dWlkKCcwNkFKQk05VFVUU1ZO
RDM2VkE4N1Y4QlZKTycpID4gMDE5NTM1ZDktM2RmNy03OWZiLWI0NjYtZmE5MDdmYTE3ZjllCl9f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX18KCldlIGNvbnNpZGVyZWQgYmFzZTM2IGJ1dCBy
ZWplY3RlZCBpdCBkdWUgdG8gcG9vciBwZXJmb3JtYW5jZS4gQ3JvY2tmb3JkJ3MgQmFzZTMyIHdh
cyBhbHNvIHJlamVjdGVkIGR1ZSB0byBpdHMgbGFjayBvZiBuYXRpdmUgc3VwcG9ydCBpbiBzdGFu
ZGFyZCBsaWJyYXJpZXMsIG1ha2luZyBiYXNlMzJoZXggdGhlIG1vc3QgcHJhY3RpY2FsIGNob2lj
ZS4KCkNvbnZlcnRlcjogaHR0cHM6Ly90b21la28ubmV0L29ubGluZV90b29scy9iYXNlMzJoZXgu
cGhwP2xhbmc9ZW4KCgpCZXN0IHJlZ2FyZHMsClNlcmdleSBQcm9raG9yZW5rbw==
--000000000000f740180641d4ce13--