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 1wGFGe-0061rq-05 for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Apr 2026 12:04:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wGFGd-006EG8-0T for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Apr 2026 12:04:19 +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 1wGFGc-006EFz-2s for pgsql-bugs@lists.postgresql.org; Fri, 24 Apr 2026 12:04:18 +0000 Received: from mail-oo1-xc2a.google.com ([2607:f8b0:4864:20::c2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wGFGa-00000002oyI-3nId for pgsql-bugs@lists.postgresql.org; Fri, 24 Apr 2026 12:04:18 +0000 Received: by mail-oo1-xc2a.google.com with SMTP id 006d021491bc7-69486849137so2834410eaf.3 for ; Fri, 24 Apr 2026 05:04:16 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777032255; cv=none; d=google.com; s=arc-20240605; b=VqU4+BY5Z/FaHPWR1CUdJnFCFRP548uxexcubyWvE98L+ze2P414ZmMZJM08NZFdKm mi2d8XHBS5p67pQDa8gLZiRnEne5Mh0IMeiu7TikanayFbRwAhkC0fMG/90az+1K8t32 Um5JCnVSVohmhTXMw9WEujBFogSSlJ6MtZqELPibF01kDsguAv0Hx4MbKYC1k6RY2VZh J/Xl7rdjQdQkBw7k2Ozc7mG3kTJ3ehChDgjRkcdPH1xt6PmYRXqzXWHkXc08HsUI7Gga qxpx9Mh2MK2E8bmEvQQZXItPa3wk9rPi6upQDkvlONmaaAktQrLY/b8n/Hb9SvoJZRyc 9wDg== 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=xM+zCruqx9qaEI0uaDfpMFJ5Ex6aeFlLlHgwC+KXQYo=; fh=TKGXXhwxRrKT2xXpPBigvWgKa2wgIIazb5LrxdXCwnA=; b=a0f6TAFFh2/9xbM+W8i1d5x8uI61LcSV4MDZCvOKrnT+U9wtR4g4vo2/LoNejbkQp4 go8mLVfz5WEjqVWEO3DdCJK2xRO0D5U43YUC0XR8mclCA88JtdP9B5sPMO1uz3W/RYZB fqAO86Fj1eyc/6/lgo0tYg1fRLQB9DFdN2MgDhG1IUFuTlqj19Dhfx+XD8kyJoN+XB4A 5QEuUIoA1p6nt0TPqYE2Wz45TG+ud49b1Feax2soQZ30PaTab600weG7+GiusI7Ui2ck GvDMivSd7BxTsFjvQNYbjl1J3HzBQGs8XToA26gA7TnxAEQ+awOrmQD+bQ4zSJ0wlpmS FC4Q==; 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=1777032255; x=1777637055; 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=xM+zCruqx9qaEI0uaDfpMFJ5Ex6aeFlLlHgwC+KXQYo=; b=WIgcPzf5LUZ9zIl451rXNETsQkwZ0mxhPL8lcUxG6J8pSojD6eg3LIJo72pC9wWJlD bqoCh/gxJJl0EoRK9Op9iM68AlJ1rx54Pzy0ew6PEKFSJoqZF5PLTvMk3KXEuGo28T3R Mh/hXzMyOLJ40NLyvfHHXmEpcevIkQOOT+j7brMqxnSkZ7/uusN+pNyjCXojYHdu/4Lw VnCnesxXPW9SgaxHliVWkR2JednyDtArwrsR0OAiZPqOSEyYzQm3iqrmRj3fDwDry8nc RUm4QD0vuF8oECTVzw9VX4LrljtBzIpcybDuVdqWAki3qg9KIi400yxSAMadxa69YHf9 PkSw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777032255; x=1777637055; 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=xM+zCruqx9qaEI0uaDfpMFJ5Ex6aeFlLlHgwC+KXQYo=; b=tMrtiaz7awjJB4RyXoYwKrFvTLxzz7w0pvJYtxzhktgGN4wGdHoMvdiPmLwzEbbe5e dD4N7mPPcNlQYjs28SpZXjj7nQJgLYTpFa9B8SnAia4KT4/QVJvt+5ohyUWStTyI/GOU N/RpSSYXLthW05H3Lxh0RKpNmPF//gt/qVkHaHMtrxfmtMHYfOQ4TmKA4rt66u7IFpTy 8Ry83lJiijr99j+hxdaCRhV7NgSXPu7wWB3lvnvmm8fmukmIrCJ+B3NykEj+/8gC3G23 gga1HYYqsF7Y/eC9VHJX7a7zEUqsAMsE1Flz3ONEgovmFdF3Hd0mAI4AZB+irGXsOQvk 1vEw== X-Forwarded-Encrypted: i=1; AFNElJ9kIJF7D6dNEb6lKILS5vzRcLINlh9hPunA3Z0ByzhXbxNS7SqZKWTYDUAcgqKAl5Tj/vMpdnMqydsw@lists.postgresql.org X-Gm-Message-State: AOJu0Yzy6AFBosGZyR2xhe9sI1A16xWKhlE23ubNjG7aKpFVq+rl78wN JJOTwKmVTPKj7ZESEPiLCY/ZmoVV2jrvJ6UMljq61eeF0kTGa4oLq02CLYMV4wCq7tRKdnZtLMF wSbUoGq8UpiigaKOKYuykVPrHNThmdq8= X-Gm-Gg: AeBDiev6HeZvodxReouUYuvqO5+FWfJV3YfgOREOBUyDCnDQPF8q6cili4UX+/lZqML HxDJWEUJ2XkeeGoT84COHNRsjaZNd2AcJ4RWGGfd/Cu1nQsRkJLTzWsvsxM1X4StwU9Vr92p/lT sLlsolsDv4EBpMBx6e8TWgrxA3jEr0NFqVfQek5gJdODZeYFcMkP4AiQhwssgpVJNM23r1ZAAHo AmMmUse2nNCrn74A6CmlEAfUF7C2bLupkIqnzXXnMoPaZpc1YjZZzmwgAjMw8nEdqNnb8QNY0Pz VQnXoYLARTRHFWPAIYg= X-Received: by 2002:a05:6820:221a:b0:68e:e069:7a1b with SMTP id 006d021491bc7-69462f04d43mr18101242eaf.51.1777032254308; Fri, 24 Apr 2026 05:04:14 -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, 24 Apr 2026 21:04:03 +0900 X-Gm-Features: AQROBzDaICUEFzlvHu3Jn4Se_06e51fllf5FoxxavHQeyZZoJWaoGkWpv2B6uDQ Message-ID: Subject: Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 To: Michael Paquier Cc: Tom Lane , Amit Langote , Vik Fearing , lukas.eder@gmail.com, pgsql-bugs@lists.postgresql.org, =?UTF-8?Q?=C3=81lvaro_Herrera?= , Nathan Bossart , Heikki Linnakangas , Melanie Plageman 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, Apr 23, 2026 at 3:51=E2=80=AFPM Michael Paquier wrote: > On Thu, Apr 23, 2026 at 09:55:10AM +0900, Richard Guo wrote: > > Not sure the RMT mailing list works or not, maybe I'd better CC RMT > > members. > The mailing list you have attached is used every year by the RMT > members for their internal discussions, attaching it to a > pgsql-hackers or pgsql-bugs thread is not the usual practice, so I > would suggest to avoid that in the future. Adding the RMT members > directly in CC is enough if input is required for an open item. Thanks for the information. Will avoid that in the future. Since the RMT members are already in CC, I'll wait for their feedback. - Richard