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 1vDOM8-0088ix-OE for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Oct 2025 14:37:56 +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 1vDOM6-007vtr-N8 for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Oct 2025 14:37:53 +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 1vDOM6-007vtj-CA for pgsql-hackers@lists.postgresql.org; Mon, 27 Oct 2025 14:37:53 +0000 Received: from mail-oa1-x2b.google.com ([2001:4860:4864:20::2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vDOM2-004VSA-23 for pgsql-hackers@postgresql.org; Mon, 27 Oct 2025 14:37:52 +0000 Received: by mail-oa1-x2b.google.com with SMTP id 586e51a60fabf-3d1e68f7a6cso1303790fac.3 for ; Mon, 27 Oct 2025 07:37:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tigerdata.com; s=google; t=1761575868; x=1762180668; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=qzSCQmUPoidcOlI3BQewgM6TFBexBEO8Kk62X2pxW00=; b=FzU1aRasyr5p2mbRsvFcxfwIugmveuwuY1AbSGqqSL2KzEDSav6Ylp5cZdnzuSZYBO ALggUB5WQK4/dNi+Z+oRPgwPzYN2JuvZWuNhlz50xoigFS0fq1CVamXCFi5sffxRHpFB 0B13/PwHO5mZns7GrAK/Eb34FndgDr8Og/XUO6zyFzKr72NDdabo7yHubEaZDMHzNrF7 d6BC7iwd+2QajsWD/1il/6J2uQgfXdee++YCBvKDrI6v66STqRXhsdSP/+4i5VTCJWL0 ZwefA0/XLORbsCn6nIHNSrk/vjpNVeRcpdfFyLBk2l8YRbIpOmx7de9xksLc6WGYmVVE 6kdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761575868; x=1762180668; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=qzSCQmUPoidcOlI3BQewgM6TFBexBEO8Kk62X2pxW00=; b=umg4xSwjXPbzoJVB+iOFi2M93KdQsQP7Qe7r2CrlfCGlF1j3/U2TvSNlm8PZcmKAaG odMjlerktX6OsQdzw/E2ABvkdARB9mD5QaCscrqbzGChfsPQk6AZszhB34bdpzH6VR4p sCFUSe9JUzYvX4vuwVO5+GGoVXx4+Sb3YVt3ewFcMTqOqMW6PgUc1UHn63NwXcmoSehv ybjAl8JLIaFaJ614x7zvYd0mvj0VRABiPolvfVXVZgKaSeAlJimzbwHoRwDYu7pL5Q8v s7qjopYbDISdm9m9rfmD7U4M6mUz9LwjEBNpy3C2uopHreX0wkVJJ5t0lPpUU7/51dgf 0R1Q== X-Gm-Message-State: AOJu0YyMC/qR7+lvCT1zjXTmUXmqAph2LaWHbwZVcR5om2jEXTP36SB/ ANOaKGtxXd9/f1D7lJbiwvXl+h/ocr5dnslsrnJGwg6VdTF+QJAN35WCq+KBW69RjmGhXQu7G+M M5V3nqLDKWSBIa8t0pYibbT3PJ+kx6Ik7hJUUEVjpZlf2pqJjEP30e81G14iu X-Gm-Gg: ASbGncszBgm2Dr1iOODqX0DfTBktFq6pTM+OHc5aKvgeOcQ8HqdUZZML4GiDZrB38PF 3SJINXz9z8fWM7zkuYuYUKH3XKl280tIUkwVYk1kZCcbm9pr+rQ9auWuRAo0+bkA4emtoyPlhmk JLxlbTx/zMnHFQu5KKCI/pfKso+hanJpi+FTQFIJm8Yd0lRNyjQrFTkB8eMZV6ZVjLK12ofe7+u NBrWkfe9CSzKhM+TvFU8OU1sbIinIWA7tn/8frNI0zQPfHZjkAx64Qdl9Y1kIdMEnr5q3WZ X-Google-Smtp-Source: AGHT+IEO6Xdvty0BfxliETtIKWLZM7aqg+cT/3li1Zwk2EBavA0qxMfDSuO47oznuM7yTpZvH2Da8j0TpV44uO4BbAk= X-Received: by 2002:a05:6870:13ca:b0:3d1:d26e:e163 with SMTP id 586e51a60fabf-3d1d26ee317mr2972097fac.3.1761575867941; Mon, 27 Oct 2025 07:37:47 -0700 (PDT) MIME-Version: 1.0 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> In-Reply-To: <1228470163.787783.1761573789233@mail.yahoo.com> From: Aleksander Alekseev Date: Mon, 27 Oct 2025 17:37:37 +0300 X-Gm-Features: AWmQ_bnIx5Gt8t5KtacrYfrp77u0_F6IPCIlG9gDQsaAEbNzcvhGtR8tHwyCkIg Message-ID: Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in functions To: pgsql-hackers Cc: Sergey Prokhorenko , Andrey Borodin , Masahiko Sawada Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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