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 1vE4ol-004Kny-WD for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Oct 2025 11:58:19 +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 1vE4oj-000UXw-Qn for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Oct 2025 11:58:16 +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 1vE4oj-000UXn-GD for pgsql-hackers@lists.postgresql.org; Wed, 29 Oct 2025 11:58:16 +0000 Received: from mail-oo1-xc34.google.com ([2607:f8b0:4864:20::c34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vE4of-004sQT-2O for pgsql-hackers@postgresql.org; Wed, 29 Oct 2025 11:58:16 +0000 Received: by mail-oo1-xc34.google.com with SMTP id 006d021491bc7-654ef376363so2311506eaf.0 for ; Wed, 29 Oct 2025 04:58:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tigerdata.com; s=google; t=1761739091; x=1762343891; 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=AagYjRQ323clgkzcS3fsfbxgQobx4LRKpFF+n6CpbL4=; b=N3LEo7pzTsfp3ZfF5/qWH86OzpMNGWfjb8TXQdgIWv8a3vgn9YOvkRMFLr8CmCwrRP 2D8Nt2unEmMKty+meXifLn2yfc3Zt+z3+w2dQAHbhYlQQZqGbT/Cxp8AQ42C3rw+BGq9 3yjeoMZk/jndvDN/epGTJ7aFGOtkstLAQ8GSrfNJ6XVL4dx9GDC1TPxzSXCWuy1vVz9S sqETGlyuPWdh/a31R1MpKchEsi5K6SqAJGHYAUzeQRUqkujSZ988ftvn/pldV9IyHR8i BLj4pjbwBfzL2bMGYzQFOv/VBJZ/TfDaHdDGrxUgba0pGB4R2YppJ1Ns0aagnJpvrWhL ABLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761739091; x=1762343891; 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=AagYjRQ323clgkzcS3fsfbxgQobx4LRKpFF+n6CpbL4=; b=cth273zO5E065xoKNkiZug3hhPW4HSR+oQlXEazx32Ywx1GaIYcVfKOI/9Jz05ReWQ mqnYj57+lqWG+PT/wYn5TmiGAfaXM2d63Zb9+7pJJOtP4FBsr8rBKsgWNuvjV/KJCFN7 Pk8GHZF1fuwy7zEX84mE1Uvo/BXswI3Ov+5KZDWlOcYoMqjiglUZmJJj6nO9YOAbBQXJ /rG4qrbjPaUEiu7KF+4+459kMxTAiASke2lSY8Db9cuNl0oX0ywxayCjPuCvXNoMH+XG Z14H2r61KoPOG6dbXc95G51M3LwK0dOK0XQRUv719gDeBJtihax8DPdyMSmQZclz6T5M lvZg== X-Gm-Message-State: AOJu0YxJFk39KYcu0DmqrfHwRm2HDXVvivF4SVPUTgDk8DVQkc4vwd4z Irm3LIcU48dat47p4HV4G0t7CyRPs/5ekLAwx2yB4vNM7PsMurKztkp8vw6p9e/4lHju9Jm9qyK ECIH0XadhILuhIfagFnOroFvuYpzTeoXBESRCc+YkxTcm/31QEPd74tY3TY3p X-Gm-Gg: ASbGncu5mOZp1jANck59+qlB3Plu7XOndNwOLHDyVi4kRIEXcOsJD6rXk7mYIEUXFJ1 ggwO8BKXqWRbKG/N+Yzq3z+BCdSEf05qSDQYI16Wx2R0WyZ4juIHG7kj/YWUdyCfrxmgERsRKGi 0h0Pg6wEex3KIqM/J6Wr0ghsLqU19p9Y9aY6XapPNGbeADuIfLyhjbT1kqNyOv6oTb8DZ2afCQL wnunaustaskklO7G+1sj449MhDFhPyKchbuhQD1ENMYLBBges4i8gHV3/PWTz3depW5yr6e X-Google-Smtp-Source: AGHT+IGTzzXxuPQZ2i4VjgpD6Yh7rRM4ZPxGDLK//Ypd9AxTFm2GxzU5MLoxz0xvuzK2iYRBvxmz8Ikt8Guc1J+fHPI= X-Received: by 2002:a05:6870:e8c:b0:3ac:5502:b501 with SMTP id 586e51a60fabf-3d7481a911fmr1225099fac.23.1761739091585; Wed, 29 Oct 2025 04:58:11 -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> <87ikfz7zcu.fsf@wibble.ilmari.org> <87frb27zg3.fsf@wibble.ilmari.org> In-Reply-To: From: Aleksander Alekseev Date: Wed, 29 Oct 2025 14:57:59 +0300 X-Gm-Features: AWmQ_bk_goaoqiHJGMjhp1Y81eWyYK5_oNY9gDXLYoNhNMhrueRNqEUGiudc6oY Message-ID: Subject: Re: Add uuid_to_base32hex() and base32hex_to_uuid() built-in functions To: pgsql-hackers Cc: =?UTF-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= , Jelte Fennema-Nio , 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, > > Updated patch attaced. > > Perhaps bytea_uuid() should check the UUID format. Consider the > following example: > > SELECT uuid_extract_version('\x019a2f859cedffffb99d9c55044a2563'::bytea::uuid); On the flip side we allow this: =# select '019a2f85-9ced-ffff-b99d-9c55044a2563' :: uuid; uuid -------------------------------------- 019a2f85-9ced-ffff-b99d-9c55044a2563 So I guess the patch is fine. -- Best regards, Aleksander Alekseev