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 1wIcbY-008IaL-20 for pgsql-bugs@arkaria.postgresql.org; Fri, 01 May 2026 01:23:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wIcbX-009UkK-1n for pgsql-bugs@arkaria.postgresql.org; Fri, 01 May 2026 01:23:43 +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 1wIcbX-009Ujx-0x for pgsql-bugs@lists.postgresql.org; Fri, 01 May 2026 01:23:43 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wIcbV-000000049pW-17aZ for pgsql-bugs@lists.postgresql.org; Fri, 01 May 2026 01:23:43 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-7d4c12ff3d5so1448601a34.2 for ; Thu, 30 Apr 2026 18:23:40 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777598619; cv=none; d=google.com; s=arc-20240605; b=C2TkjWq5Zo5PdyFIXKX8IXSAyD1VVR+IFcrvZcxLdiS6ADln6uvYnX+150wnky059E ko3yQMbqAFRwl8KoauGsVhOYMt0sUZTpmFNMcT09pJnXhoCzyYbi75/CIYeV1AW/FV89 26PzntiY5KnxkaoVr7WMwBgf3FnVwdqQUuKPg6ntGD6TtUCqZ/2913K1qEGDm8fAzWrx uWp6zVhpzT48Yb4zFmfIsmXv/NOBsutILyNebrwQcWLROfDPqA6oOYd1AXJBOwSw2Wde INdoA9fjQEdC6YD/yjcqXKEGblxrpXwZ+QAqXHtCcGznFLhQh1RBK7MlARExRtzvYOnt nuxQ== 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=EsYMr4mcVCWac36LxNpqV0PMFCiQ4l9PJajrleZB6/4=; fh=LAngeGMYzUWrGhAfdEPIfBGTLsnNf5C9wLW1pW/K3Vs=; b=RF/kM6FG9nmzVEfWQGFShQTbJMVcNVbDTnKADHvOVok2OYas8kBS/smz4ABTeQpQh+ ouUAfcDnkJufN4XhjXQrDPpcQqWwOX7FqQSh389XCpm3t39xfU1XWilJiHgoE6N/M+NQ rykU0OZJDYezkaHq9dxNKtinrC9oDfBfCScBB9QoMcifdlLa3LpqNf1xMtV2TrpjXZtu hiZ1Fm4uFzbWz3RRySsdha2rgXCQV1NLaPzxLSwmvjWgKfG1jUcCbipE4kj2NdFBnOHH FgOd6wAzD4xqc+lBTz7A7I/CPzecncAYJ7bou2DpgVA8u29RXqDGhooy69y/nHYlnmsS 7KMw==; darn=lists.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=1777598619; x=1778203419; darn=lists.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=EsYMr4mcVCWac36LxNpqV0PMFCiQ4l9PJajrleZB6/4=; b=R1OG7/GpN3EJyt8GhZLi2FbI/0qxq/iCkIVKyVNt4fWp9XFIT4yKWWSgkBwo045FMo nLC14jeFyInStFDXpBuyQ1Cb3sUOAhQh+LGDCvzo3X3MNyvzwB2jCKQqD62K9fmEA+JU /SANBGTwT+xDvfQxde79AuIHI+61BfgpLiNjkky1TyLpPnCmLBw6g37JMfN/VGOcIa38 ANY83BFigDv+yqGfl1WekHnUfGJ74rLnKbWipd6MsHOC+ny4rxyndAMfHjHl/BWZq1ny 8fJ/lbqpPCRCKE+JOQiJqmVy/2oIHj5MxTa+hG+Th9pKIC4AadmyJi2An9HP95xdxJUV QDzw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777598619; x=1778203419; 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=EsYMr4mcVCWac36LxNpqV0PMFCiQ4l9PJajrleZB6/4=; b=pGKv7M6JTcd9MUyDggiRTwbYrDcHv/88vnvLnTv0yMm6dtCIc2gUCE2Y5TpJLuUL14 cl7iq2R12znoRbaniJ4au9dZP32A6EsNP4ntyU0t5t274cxu9JZAwo2mmHyXKtV+q1TH Ig+8VBsV9f6o2zbFQAB5drHtEZ6KvsFunrSdg1D4LBGXc3c4+N91ZboTgc+bcfDiAfHM 26QsAYrVTSdYq81uBr3OuenmLkgKV8Bmch/XYcT7ivh6ST31+JkEjeO1zCHd9WSm6cKO gZrmopad7gta+9aQPisNTkAw/zSAw/3/kjbIC4/gaOtUuZnZQ1PmZFy0La71exy+2sRi sZ7A== X-Forwarded-Encrypted: i=1; AFNElJ/qqTRae76P41L3kjUmTN3F/A+XLmJ6pE3qfWDGtI/kvU7YM7eAeRsl87FbAq3V5tGi3eVoLJ6byBnU@lists.postgresql.org X-Gm-Message-State: AOJu0Yz86sVvxNmtkfUzRk2OKgyZSGWsuoYtrLV4M/UJ+Bz6fdZqyIkT JpbkHxdPuqD7MOBbwmS9+zzCgNDM0L5riliMZZHiVmtFfiQV58qyXCGErkMWHMXGlJt6DpbLukq UVX9znkKw9vvda1YZCx2/pszEZelivFU= X-Gm-Gg: AeBDiesJvfDkO1uueGY3IWq65lD8HW9HGFuvoyDBXvSOM4+YLSyAu/OEuz8W2/nLcpT 1y4Yi9k65siikwpZvzP1CzP2qOGr3fxAHdFJHCYT+GEEFTE3LyR0/Sp+V6oiy/6tv5uEPbJ9yKW 02CSSyKL/w+6EOMmuPO2i1gIKm2FSeYBuhFIVrvUdwzJ34i4OdM7SnPuPe15h7C5PHnoFOgG0Ls ypF2L1UHbpq5bjkvmyHriI+LXEpUko9Kydl/GWR37ZY5yU0y8Cvk5OjeAXsi9tb8A69ciqA+0Nu SZrnETK1BllcavW2VgO3 X-Received: by 2002:a05:6820:1b14:b0:67d:e7c3:3c65 with SMTP id 006d021491bc7-6967a649459mr2908670eaf.56.1777598619100; Thu, 30 Apr 2026 18:23:39 -0700 (PDT) MIME-Version: 1.0 References: <501040.1772433449@sss.pgh.pa.us> <485641.1776738632@sss.pgh.pa.us> In-Reply-To: From: Richard Guo Date: Fri, 1 May 2026 10:23:28 +0900 X-Gm-Features: AVHnY4JZ8_tSgzSxgMsfKPckbtPrZkEjTJCQ85E2MHs8k_7eqSNCPi3qu4FQyNI Message-ID: Subject: Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 To: Melanie Plageman Cc: Nathan Bossart , Tom Lane , Amit Langote , Vik Fearing , lukas.eder@gmail.com, pgsql-bugs@lists.postgresql.org, rmt@lists.postgresql.org, =?UTF-8?Q?=C3=81lvaro_Herrera?= , Heikki Linnakangas 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 Fri, May 1, 2026 at 9:26=E2=80=AFAM Richard Guo = wrote: > Thank you, Nathan and Melanie. I now have two of the three RMT > approvals, so I believe I'm good to go. Will commit this shortly. Committed. - Richard