Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vDPED-008Ley-Lq for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Oct 2025 15:33:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vDPEC-0085ZK-Da for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Oct 2025 15:33:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vDPEC-0085Z2-1a for pgsql-hackers@lists.postgresql.org; Mon, 27 Oct 2025 15:33:47 +0000 Received: from sonic309-20.consmr.mail.gq1.yahoo.com ([98.137.65.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vDPE7-004W2S-2P for pgsql-hackers@postgresql.org; Mon, 27 Oct 2025 15:33:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.au; s=s2048; t=1761579219; bh=84kijhsTQQYB1P+iGW7vpSyH18i1ijAhafujaCodGFo=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=e6jzXRNygA83YQ7h3k9H//Cxk38a5zZEtcqHd2RJOlR4hwdF2xfFZveT4Y4iqC2IlPpLO5+gV0W3x+G+go4N1ciOi6qN5jZdbHrPbddhQ6GJj2ZIi21vA+eUw8Jf3rY309g8nehWGH520ZiwSaZ1qek2tppN6UUwESp9ha7HzyHdWx08o8vUyaJ34DZPIlF+R+nfKo/WkGCfoULviqIDlgzP2BLTPyhDekeGR7GUDA/DMwURsRQ1UeN8P8Bxub+E8StYIrjqnsyhTk2qTmSf87RX37ddCs3fmEkWSYYCBHix5D3nBly5ll/+t2sEfQEN+fCpeN/WXbHBO40lpxzcRQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1761579219; bh=7et6HR9lOZ16OOyfAfSjI09/Tv90RGWdTDqtNfweu+Z=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=FbyR8QhUgao5oBUYmCAORDITLBir4YKAvocVzAgGgJeSSoEHdn258viWLc3KOCeFQrLlU5fOF6tjy6yarCW5w2Nz/0hHmiVXZ954fQCofRrcDIIQouZUr5JLCQ4arvI9HPiAprGI3oSiqfU7zJBYwLoLs0hi8vwHW9QCGXQYWXqnYj7jhTajYuo53dR7UAVJIi7wNVZLSq3JINlQfD+Yjd5sDa1IiSmns2FdEh7JGt2oxLc0eN4wyJkIzYvQIF+NuqXtnyPHRW/cMw+0c+ViI8D688zPc+whPUQeMF0bi6AVwBSiSznRO+8UyWYuVkJAyih9YTTWElLdFG3D9zsRfQ== X-YMail-OSG: EELWNwAVM1nIAhMOcjU6KUFd1xbTvt4m6kd54WtwhV9ZHNLnQF8873VAQBDQnDX nIhAf1z3TGO5OIkjQoiAcaU35IkxBgSxSUUZp1GmXELCmB4DPmyoYxyGDiAAyZmiFNS95M6VKH61 tRzDAwVb99AtXeNn0uk8XNURAdSGA6rJCyUNrp5fx1Tk3IkpHcP72owKBvdpsWXCbcDzwP41aeYW okdqGJl4iJg6fTSjD585WmPv1R2lxc.S_.KLJU0mPkQ1j2J1LGGONp72jVpv_KJIGRJ634g34vo8 jJtFBWEU1HZQuX9clHVjP9QIZExvQ10Xn5Gg957CfaQXEPdgZJIpESvfLBJuyGvOaMg2DLmUrbLU GGOIK4Spish1.tpjnkWIcktFUW7ktiYTkdX1YTyWcXY8bb2tfWTwlhZTIN5jZR0pXQkF38jWnlvI 0fI6MiNETRweRtuqCNzP7uuBmQ_C0bz.vFvVwjEuCVOjkI4a.kaDDFcSU1RQn7ORv3tleIb9mOdD A9eobt7Qd.5W346eBvNqEb8vKrjBjWcIRbARt_DEuxK4hCn.Nd6w_Jz2TwqAfaw3.8qqF.zInhsS g0ftW3vm4LS0zsBgdY6aOtQi7aOhRNA_cltPXST7ZlS.pArMICggOZg.DBfCqGfeUG6cHtClCq8k 9ud.2wAuYEyoUgEEqA3jI8xtugtc7KzkdiovPkgg8xi4zNr.1W2FIZPtndXENBU5GsaTCJx_B11c eF__59hPKSinP2vkQG2jEIhkkPPnep1Kvwgvm4r8A4BvLJ7mrv5AlLyOyQeOhtnPJQ1zCJ8BFO9D lcUHs6280_P3dJvA1fzOxU_5A5QyhVXVKpzp1RDBbxMLjdnP8WkseL4b1UxHN_fLEivmLZHtLTEK LsmYlWOA5pksVQf4E2AlZZ9depG9wGK8F4yzI4ddurKRRAZyom2eV8_VgS6lZwlTKuAatDOeKWsC hGH1IVp49Dl4LIvmHjA53l6G0xUURczfWu2YOB3Uum7oHGsO.eboijT8kMoMGkF1DPI.Gl.hQYCo sDpeXA5P8zDDnrJWQdcmXNMBJv8yV1EGA.SQSepdz03HolMMLvSTYE_wp3uDRcm_xgS438HrdK7J Olrh2dtks_LZL9HVcSS1H9NO7GTB0343gqO_1TIrUceDV.vqA99uaBEt6uMNh6aExJd3bKBA_6fw lRld9bRo8HlLxvi7vdJGRbyKeaB3NtQgycjSOcNBYWnZ9O7KxrhhITpSlsVKyrx6qRUfn33RQt2Y s4SwasYcjq8ue_NEpuLSwuA12KKX2Ekz5hGdUCo8hYVP34DPHu1HB8wq0JvKHhjX_9gq7mTBLQeV T7sk9D1hLp9JnKL6VATyirO8i2SOMFGZuetN06kbIhzNyQu8ljT1VpWn9aAWNAYQYxHH4JQfHckW aHAUt.oIKjR.rTD3PGXLrsSHm_vlj47lHAFfpYulp1iMCfPlCLu8tDbUEIqu6vy.LHtclOW4tHcX 2Rkpm5_yES.FPVYopBx5SoHsVedmI5Yba5JCwr_rTwwq0vRapUnGkXwXbmRHaN8HMvt9M_XO7YVi o_adsjpgcE1kl.9KrTZ4MN34dyTK2pxO2lg7w5Y1HH2_bsneX5j5a4cwslDGdU_46Dt1zxKXZ3_A WEVsMDN1yapJb2wV8om75.5z2zpFtG6.ilQDy9aNoux1OabRdwqqfh41F7cZY76G6FrJXDmvdzRq bNAdPlLE62K.7QOsTXDJyez_5XJbDVJ0HrVh6vwg9PuvLngDw0GUR00c90aFMPF.u7xM6ab7Z6kB cMhb6zF7.5JT5N23WEZSvpcBecn1XtbkqyugXnoXpOu4xfCrB3JLQLYSQG62S8awlGDmHcv39vGp kAZqoGB1FyLMBwuaNpKRvnkUjxdYQfUoAmzxTTw3vXz6U9IIyeClw0tNuplGZRW7VP_NAHiTdTHg ht5QVogBQ34IGsHEhclrW6mh5ZEFKBeyFRlw6qFMco5AsK1RAUvRVNu47Nv6Em52cUiPEuo65FSA C9LI1_JMZdXpK7OmEoshM4oHmQ4SlrIdlYztz6aHDyR5FVtKjxXSzxseRgKfx3hluwAquSYR7qi6 8Tkt7gzcDtMCbrqhIU_aguizATCvWSJJqB1A1.yKBLrTCpfN1.QxcUdm8xvXXcSLAYJ0FWyg0tMY TJmCaeylgy14oOkQ0AlldmWbyzjaYk4RuGIG6im0IV0Kd3FLF0U1Tb4.RjiV0hFJixWcm6ExW6L_ Cd2SQ1P5534PQQ1vKqoos7PHYst312o42c31Rl3ty69OYLG0y8ypnOiEetNFLIai5_yBMsXhHiTq V.Cs- X-Sonic-MF: X-Sonic-ID: 2c9dd0a3-09d1-478d-8136-6377f2934230 Received: from sonic.gate.mail.ne1.yahoo.com by sonic309.consmr.mail.gq1.yahoo.com with HTTP; Mon, 27 Oct 2025 15:33:39 +0000 Date: Mon, 27 Oct 2025 15:33:31 +0000 (UTC) From: Sergey Prokhorenko To: Aleksander Alekseev , pgsql-hackers Cc: Andrey Borodin , Masahiko Sawada Message-ID: <1244660844.809618.1761579211494@mail.yahoo.com> In-Reply-To: References: <1791665551.452444.1761209220211.ref@mail.yahoo.com> <1791665551.452444.1761209220211@mail.yahoo.com> <18022523-0F8F-4C07-AFF5-57DC9086D78E@yandex-team.ru> <1895971769.8343.1761240853939@mail.yahoo.com> <574624399.175025.1761290201491@mail.yahoo.com> <953203149.383019.1761345585325@mail.yahoo.com> <6F76FA61-E2DC-44EF-9504-889D9BDB4EBD@yandex-team.ru> <1228470163.787783.1761573789233@mail.yahoo.com> Subject: =?UTF-8?Q?=D0=9E=D1=82=D0=B2.:_Re:_Add_uuid=5Fto=5Fbase32hex()_and_?= =?UTF-8?Q?base32hex=5Fto=5Fuuid()_built-in_functions?= MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_809617_424747742.1761579211493" X-Mailer: WebService/1.1.24652 YahooMailIosMobile Content-Length: 2788 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_809617_424747742.1761579211493 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi Sergey, > It seems that bytea is your personal interest, since you continue to impose your bytea when a better solution has already been found with uuid_encode() and uuid_decode(). In the previous messages Masahiko Sawada 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'd like to > hear opinions from other hackers too. I merely shared my personal opinion on why I think this is a bad idea. Let's see what other people think. -- Best regards, Aleksander Alekseev _____________________ You didn't give any arguments in favor of your opinion ------=_Part_809617_424747742.1761579211493 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Sergey,

> It seems that bytea is your personal interest= , since you continue to impose your bytea when a better solution has alread= y been found with uuid_encode() and uuid_decode().

In the previous messages Masahiko Sawada wrote:

> Or providing
> 'uuid_encod= e(uuid, format text) -> text' and 'uuid_decode(text, format
> text) -> uuid' might make sense too, but I'm not sure. I'd li= ke to
> hear opinions from other hackers too.

I merely shared my personal opinion on why I t= hink this is a bad idea.
Let's see what other people thin= k.


--
Best regards,
Aleksande= r Alekseev



_____________________

You didn't give any arguments in favor of yo= ur opinion

------=_Part_809617_424747742.1761579211493--