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 1vDil8-00EG6X-Ub for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Oct 2025 12:25:06 +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 1vDil7-00CZ2v-IG for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Oct 2025 12:25:04 +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 1vDil7-00CZ2n-63 for pgsql-hackers@lists.postgresql.org; Tue, 28 Oct 2025 12:25:04 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vDil4-004hAy-05 for pgsql-hackers@postgresql.org; Tue, 28 Oct 2025 12:25:03 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-3717780ea70so76928441fa.1 for ; Tue, 28 Oct 2025 05:25:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jeltef.nl; s=google; t=1761654301; x=1762259101; 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=/AgaE1joVWQud9LxkNEuPN0CQTVYGHVZibCj5ZTdwL0=; b=TzcZbrUsUOqMYCjA0uqGo4pEEdlvTpEbxpr4QJPJYjI3T3Nd262BDpB9gRS6Q7dHZ8 6EDhPYGwI5xbQMFFfmialG0T9I4PrnBAFuxTzyG2CM9h8XxK8z06Kn7Si/lbphRviv9L A694MNZ2c999D3f4VtkuFSvz7XpnhH/NHgHsLx8bC5YKVXSuhPjh44MUJd2GBzHLzeQX 82LC03O25+iLbRT1s31UAMCAnsZqGTjTIzsDase0EMYZ2saEFbrtAZbuo/IyvCbY4I3U Z3fNfnvoK+RVvGS7VrOZjTfo+SGULTFhwLDTheGpqFgn7PktTtLQcfsoZ3juCMW5cwxq QO9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761654301; x=1762259101; h=content-transfer-encoding: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=/AgaE1joVWQud9LxkNEuPN0CQTVYGHVZibCj5ZTdwL0=; b=iC7oVtXdxir98s2XJz6Y8ZWE++x9QK21Tn6RI2s0Pcq2O9sWH1qKaXXf70YqsO6/Zr yXCZh9y/68+v3DHgRDnipgrzFKGjcmVS4a7M2l84T+7W8QpVyhb+NnLcLcnQ8hz55b9w 50oMRdJI7qgvJZkRKkJqBKW7kC03EBtZI8kJNFz4+GBxeJTGQnaVhjtpyShA9qrwUoyv Wr4gKPhygT47x841Q4sAx2+vaZgK23cYvXJhwrCIPqkOuBYF5B69ehy57EnpnMHLcqw8 f2pP8hLIHk0sF7HPmQxI9JKUu46IrFv1SBvHQEmP95zji/fzlxgQL5FYm24s9aJ8IvSW qZog== X-Forwarded-Encrypted: i=1; AJvYcCUqMHqesQtt/30tEc9UyQfNBJU0jrq/Y3YLADehXHK37ZwsI7eUrGuqoQXJgzaI5tH1FZrGnStpy61H8/2J@postgresql.org X-Gm-Message-State: AOJu0YzQpLC9dkzN2ojgBZ+SoNFDeFOqXQi1qNDt6owPghnF2JuK1dpL 4XOfvhvB3UJv0y+KOcG8Y7+wWvJO8Zu7SZUg14Q8UL+NICOYAhaS6IojYkUCB2euwzZX4QHuU/Q xjQCUGkaiIui83ET0gvedr5LtPSbRJrajleCDOLs9YQ== X-Gm-Gg: ASbGncvruSNSg+H6n0BraEVrlncVFYMeDsITOxuT26JuLpgSe40NGjAZgobOvOT4bcI zGWJgoKbTFMgLeoa1Kjy0QnWRqq7z0nvUQ8cX/jMT4Tq4nDvnfJ28te9Mj4x/Fo7MEZyDAw1woH a+U+CwDe+0+AXZjnEqYkn3k+46k9pXBpgFOa98nl67Q3zAnvIThwpehDlek0pblQ9IIq0hau5AU FsFTZmEciH2fJNKP0xfIetybhCOFPjWivgFuU+qSp2W7D26qe3F58QwCm4= X-Google-Smtp-Source: AGHT+IHA1c4N5tDo1Q3iudQtTnTi3LcB8+tUmcVZiu0hWyy6BO2ZqFBHQC1pYiQ3gCcusgmkqEkesE+sgvPP70njUU0= X-Received: by 2002:a05:651c:441b:20b0:36b:b0eb:9d65 with SMTP id 38308e7fff4ca-37907698a91mr9495041fa.10.1761654300616; Tue, 28 Oct 2025 05:25:00 -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> <1154454839.957923.1761604611424@mail.yahoo.com> <87ldkv8cog.fsf@wibble.ilmari.org> In-Reply-To: <87ldkv8cog.fsf@wibble.ilmari.org> From: Jelte Fennema-Nio Date: Tue, 28 Oct 2025 13:24:49 +0100 X-Gm-Features: AWmQ_bk3wdCQdjfccDMleb1_XqxORsSiLDfaeu97sdF9sgpXQ0PN9QR39BvlmdE Message-ID: Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in functions To: =?UTF-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= Cc: Sergey Prokhorenko , Andrey Borodin , Masahiko Sawada , pgsql-hackers 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 Tue, 28 Oct 2025 at 12:53, Dagfinn Ilmari Manns=C3=A5ker wrote: > If it's just one new form, do we need a separate decode function? Could > we not just make uuid_in() accept both forms (they're easily > distinguishable by length), like bytea_in accepts both the old escape > format and the new hex format? > > And if the new format becomes the standard and want to change the > default output format, we would need a GUC like bytea_output anyway, to > let users control when to make the change. Agreed to both of those. This seems too far out to spend much time discussing now.