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.96) (envelope-from ) id 1w6Cfp-0043Sj-2w for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 19:16:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w6Cfo-00BdPP-1J for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 19:16:48 +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.96) (envelope-from ) id 1w6Cfo-00BdPG-0E for pgsql-hackers@lists.postgresql.org; Fri, 27 Mar 2026 19:16:48 +0000 Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w6Cfl-00000001XDl-2ruT for pgsql-hackers@postgresql.org; Fri, 27 Mar 2026 19:16:48 +0000 Received: by mail-lf1-x136.google.com with SMTP id 2adb3069b0e04-5a2967e5de4so3263700e87.3 for ; Fri, 27 Mar 2026 12:16:45 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774639005; cv=none; d=google.com; s=arc-20240605; b=dCEHIvP0iU/xY03KCqk1HS4fSkU3Gh+mWBwyjd4G4W405t8dbNQKA9jQK4Ji66lzHD znzdMBp5Tjwi3+KQB6IrlW63eVSOaKmaYeM8FyQWdgqCvg6Ul6vbeZptEGslo8fMC5yl 2l6zvYfM/dw76AOMwj6O4ASnt6BkPgJtFBUUWm2Z0ctlHjXeGHDS0ac996svpgAie8mv HpbhY6pL9STMOdHnImiv2Qf2dMDqiZ34qKEsz9P9ybyEQaOCUoyOdNO/N2XSufv3n2yi 45m1KPeSZvySZC5uLaot3uAzRCu8TwIVf+JtCPXbe2Anyw/yweNr8hxFGSl0n8WzoOtv I8hQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=vliwgNSoYobB8W+sCsIdroEAbxBbZ7bCI1zgQuNE1hU=; fh=mR0h6koVllENUhkLHIO2s0UvVMR5LBjigMLCwMHuAKo=; b=DB9SMyUnrUDqVhlDmeduYKTYqz9Q7s8kUW84jVzs6lr0W2D+J9QM28mF9y22b1h6r2 TZtRCKHtj9gkIE5yC0zc3jnj5Uxlllnnwe25eKkoC29KOlYfixsY8VRQdCAEgmWVnuZ8 YEpzkacKJOtuiJ4aA04CBoombaDFcKbUyFm+tcKqgOj9UgTTLTgjTqb9uG933/e6n9Uz HAarT9iSE2lwV/Fq06DtnLMirBtIJw8uopj4fpFVONeuM+t/lc1tobGrOaLcvsIpfR8/ wvpX2tXnxtPbFohOJ4jRW6jF4lYKnpOB89OwrSk/YiUh6KzjViGkFMcqSIFijLRFZhYG lQcQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774639005; x=1775243805; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=vliwgNSoYobB8W+sCsIdroEAbxBbZ7bCI1zgQuNE1hU=; b=OXCznVhnzphJXbNVfbj7oEf69pPHyPU+jOJaF3H9sf8+5BXHX43sk2eQ7r1S0Bf4lu fCwxA9aHi57RmFhsLHmeuuyZJqjPoXjhcs24xnZzaaI2etcCOcS4u3MbyTCm66rPSCFd ZyG4TCr2XX6uGx9SanT+ITi+/M5g/AZQ54C/7ovONt9HMDd/jMACTHygdd5aAknkXFRC 3BIbZvl+ktKJ7xyjSGNxYz2G07/9HXzNCU0vImOuh1uehvhOfzAefjJqCJj1jlk8O+/Y +/Gy+hdcSTtH5EOVq5UZLcHnVotQp60krORQiWET3d9x4qGQPvgnCX0v0xin8vkVz8lh duMA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774639005; x=1775243805; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=vliwgNSoYobB8W+sCsIdroEAbxBbZ7bCI1zgQuNE1hU=; b=XSrR6qtGBwGzJjkyE0+C1B5IRaSMpkRsHke4xjF/Po+dAxXnLEantktLhkdA3VRRqW akQUM0s+s46srrFPkwj6Ti7U+hIgfuCujTP3CWSrZxNwC2jzPjB7+f08RF8UDfyQziEw wjtaGBnx3MZNtftjrpz7WcBO+4m6s0GsCwn2khk+7Vy20yS+W8aMXEE7VrWcvYRiOvEz /Rbdah1xZw232XtGVt8mo9N1t3DimJ9uxR2bw2z3s+u2S1JJok/cQtcJfrnEHNNR5Mqb s7uGelsI0QO1xEGLX7w79S5rImODyHijXFY3XcBo3kFJD22WL/yggEoxvX4QXFAn/QS0 AiTQ== X-Forwarded-Encrypted: i=1; AJvYcCVlX0q1unA/V9QabO598s39BK1QzlqvY/lZcrzAI2eZM0qpurWP3X9o5zCr/inXjbCvxCTWqnkYVBxYtHEl@postgresql.org X-Gm-Message-State: AOJu0Yw3dBv7FPhXnizzZqOVCqnHO9XDY0/KfCawqHSR8aAlwqGJVAXq plOPuhu+tgIAIScO/YAqKwjULfwsych+tqTalCnVMYN/708MIBYhHSmlCRQhwP/pmkFDAZTy3XZ cvYmfMto3Fi2wHqjRGbY4dnBkoekdnNg= X-Gm-Gg: ATEYQzy8bvP4lh+m2PrN9sZgD3Syy0e3w2qT48t6S5mY34AKsvYGa84pO49gudTHIxE 8BfWOyKQZKStxnAo1jic9IrjTDGOp/Mj5uGgN6aIaMvQsesw+bHTqQHP1jmcBegNp/DgCrTKtqO HEQdOZvomVEXlcX1emd1yPNUKWw36qIIeL1/lwilymbG1EpxhISB5BDdB045Cj7BAKk3TO9rZLu qF/EJ07VsD+BIY9D1v/PLXrGt1m44TuTXqnLVDOqm1pLruf86vsnXvg2ZHzybjY9u3j8wou4JJ2 4+aalOg7 X-Received: by 2002:ac2:43d2:0:b0:5a2:88a6:3096 with SMTP id 2adb3069b0e04-5a2ab9299c7mr923257e87.30.1774639004254; Fri, 27 Mar 2026 12:16:44 -0700 (PDT) MIME-Version: 1.0 References: <1791665551.452444.1761209220211.ref@mail.yahoo.com> <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> <1154454839.957923.1761604611424@mail.yahoo.com> <87ldkv8cog.fsf@wibble.ilmari.org> <87ikfz7zcu.fsf@wibble.ilmari.org> <9CB824CC-70DC-4165-AC6A-9664F47209EE@yandex-team.ru> <878qbn51kb.fsf@wibble.ilmari.org> <1F13AF7E-B90A-40FB-B47C-DC38FBB08353@gmail.com> <682417.1774482047@sss.pgh.pa.us> <431D684B-ABE2-461D-AA26-E009D2630CEA@yandex-team.ru> <975FB674-1C52-4431-B80F-298075198F25@yandex-team.ru> In-Reply-To: From: Masahiko Sawada Date: Fri, 27 Mar 2026 12:16:07 -0700 X-Gm-Features: AQROBzBcsaAPT5oUvx3rDGSG-VGDWEvMNR6JxZf84SXTTdZDOOGOoLHwnVTmDr8 Message-ID: Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in functions To: Andrey Borodin Cc: Tom Lane , Aleksander Alekseev , pgsql-hackers , Chao Li , =?UTF-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Mar 26, 2026 at 3:01=E2=80=AFPM Masahiko Sawada wrote: > > On Thu, Mar 26, 2026 at 10:59=E2=80=AFAM Andrey Borodin wrote: > > > > > > > > > On 26 Mar 2026, at 22:30, Masahiko Sawada wro= te: > > > > > > Feedback is very welcome. > > > > The patch is fine from my POV. > > > > Please consider these small improvements to the patch. Basically, we re= ference to formula stated by RFC where possible. > > 0001 is intact. > > Thank you for the suggestion. It looks good to me. > > I've merged these patches and am going to push barring any objections. > Pushed. As for the original base32hex encoding commit, I'd like to leave a note that I've changed the patch to use the lookup table for decoding before the push as it's more efficient. Regards, --=20 Masahiko Sawada Amazon Web Services: https://aws.amazon.com