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 1wF3vB-004i1n-1n for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Apr 2026 05:45:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wF3vA-006W0l-2r for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Apr 2026 05:45: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.96) (envelope-from ) id 1wF3vA-006W0a-23 for pgsql-bugs@lists.postgresql.org; Tue, 21 Apr 2026 05:45:16 +0000 Received: from mail-ot1-x331.google.com ([2607:f8b0:4864:20::331]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wF3v8-00000002FV4-2Igj for pgsql-bugs@lists.postgresql.org; Tue, 21 Apr 2026 05:45:16 +0000 Received: by mail-ot1-x331.google.com with SMTP id 46e09a7af769-7dbff06e4a6so3825460a34.1 for ; Mon, 20 Apr 2026 22:45:14 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776750312; cv=none; d=google.com; s=arc-20240605; b=ldTr7G9kKR6V0oHr4aShN0gujHYaGtJuPRwoNphOcH8oTQqrYaDd/OLyT8A34wY4UY hoD9LbDr03o2KkAFnymekZ+XARA8i9baivBT7JfU6UkYZPvJZUdPwSKgo5eNmUWDDcYF /A8Xj9Nj2bw0n6jsM9XmUvALZakCX9Jo4TDuPgr4YVYwtGIwBMqWzjwyXV44BDDaZken z5pJLc79N0/e6pLPo6SCDFf5xO+c7u1tYa8WSwyRqpJbq5BVioEwKPXDl/bYWNg3cZ77 /rVmNEtvp4ss/il6N837MyrVOmGcIDbY3pqIgfyQqvcP0PWXK5ck/GtBbSfR7vwoJst+ OpZQ== 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=g0UKBTTCeSMhjq7DXckFXAwFQqxDRsP9w+Jan5U6bzk=; fh=fUgRleA6PCn+E3b0v2TY7oSwC/y84K0olcyLNHvGhwo=; b=C5oQO4x302bSB0nfHDZSpr5N9EtYWkfgu/zXuxaYMVR205kE3hKNJfnDhy1wfMbzri vQQYQu1ecTD/bf7b1+UDExjYFANw+MtmQAYF9kLT+p3G+zFiEROKqxfuhG6JKdr6LN0h VmrvvseysYENcNSZyQpuppSpuEiaLehj3qoerWTPf3F+RGTNuff/GG2Rpag5V4ngPIu+ WUP468dFLNbZEb7dtmaqTsifc6q7DZq0ZykdaIZ2snajGD0sLX81EBXAqR4c2iylrxKb 0ESDOQSWB489TJXyJJPd+3iIn9j/QxMy4386Hjtfnl2EN5Aof5Z/yXbjECrrlWuQ76d7 pE0Q==; 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=1776750312; x=1777355112; 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=g0UKBTTCeSMhjq7DXckFXAwFQqxDRsP9w+Jan5U6bzk=; b=b4wqQTmj3OzoqZ1lXaB3iQf2xlbmD0otUIgIEakdqwxnVoxTbFBI19+OmPj6Ixbgx9 /+dOCy5xIRO5gd1A+JJlecCGGZRlk86/xHtVXuGl5d+3r6DasuckXVl5X8Dwja/4Ziky ICa8i8PBtShAAbVR6ZHfoQvzFPVC9wcRA+X2zF91zzgCo+5wwp1l9nfVxgniD9REayro xx+x5JrY2ugssZ2BARQaA6J+xArjodawCBrBwxs6tQ65gj06L5iD/tZAfS96jRNpepEH Lzui6QH6Y5Uanzo6aZ44t2hjDsg8203Nsuqf4DgVfLFCzzA9akhiPe+3UbZ5jIjNgYfP KFGQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776750312; x=1777355112; 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=g0UKBTTCeSMhjq7DXckFXAwFQqxDRsP9w+Jan5U6bzk=; b=PGqNOTtkjbKaMEwM3fv7HB1FN9THnqQIeO9U7d4kBI9Hm5VQH0Tk4hy9cR6DaYVLIg T3neHOih/qO7X5DNJ4DBxXJvvp2KNKeeOO5UVoLYxEAjSKGzYwP3Jc2XO0dbekpOCvid NTQo9J85OerxxrrdExC1fAUcI9jufBUqZRxpIG4pxVjwrXkRwTB+AEsUa9HQ4qREx7Rc QvClfPH17zU1KvKXheh28Rc4qJqDVV5Wovp1SWmYXsGlHr40dM6zmCsFBYfg1s4F1e0S qbWSxuuWDp++teEGJx29AfhhtAAFJcq04ZaU9mJ2Dr/9xZZ3WKP+lQS3eA9QVVQwDhcn skmQ== X-Forwarded-Encrypted: i=1; AFNElJ9cTrzNtPeetDgjb89KgjXlNjTmXRDBDkp9pY4l4hlD36H4ZGfntBLMekDWm9SkM+h8d2mxh51v4IRK@lists.postgresql.org X-Gm-Message-State: AOJu0Yxxhh4RiKjnIlJGORe2mnmdAQNpYJ8/cHaQkaDTKVhg31PZxqyj FukXUOlcMwFqZALUUA+uqGrc1/FpwIKdL1AxatTOyzmtfLOhRD/pBXsw03GwlPmYevYD7d+YmKu LNRUphWy0B8HMDOg3X1JzfapCyJtnMuQ= X-Gm-Gg: AeBDiesA1yT0dxmuzrhCGmLcdcqI7yV33BrQAK2JJGqcanrh0AoX2m3Xd6kxJdOhfkw 9DppuIp/QQhO3UJ9jvucIX7l/pNqYKF/65YEwdHjzkkWX3tSZEvpwq/3BQ41ZMDcLo0jvAy5qQl rhtjM5/1JvPBTmsjDrQTZ0X6ZaQ61ktkdfpyyFR9HWBWyqoaq1vUmY37KC3jSZM1nvjB7Z5HuBt LPOg5MMluEe59rz1ix3tlbuydu1gFZeQUsPkuD2MAsLnLNCad+15jaF29Nu3qRB9MV6LkF03g1W 6bgtw7AnL0QlW94MQdo= X-Received: by 2002:a05:6820:907:b0:68a:13db:8742 with SMTP id 006d021491bc7-69462e5e10amr8977808eaf.25.1776750312622; Mon, 20 Apr 2026 22:45:12 -0700 (PDT) MIME-Version: 1.0 References: <19418-591ba1f29862ef5b@postgresql.org> <2abdb464-27f5-4759-bb0b-f09ab5b5ceab@postgresfriends.org> <501040.1772433449@sss.pgh.pa.us> In-Reply-To: From: Richard Guo Date: Tue, 21 Apr 2026 14:45:01 +0900 X-Gm-Features: AQROBzDsy3EKf6hPK0JyD8tGJfk58AWmzXypi-x8zDZ7k5r65N4KTyW1qx2_ze0 Message-ID: Subject: Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 To: Amit Langote Cc: Tom Lane , Vik Fearing , lukas.eder@gmail.com, pgsql-bugs@lists.postgresql.org, =?UTF-8?Q?=C3=81lvaro_Herrera?= 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, Apr 21, 2026 at 12:57=E2=80=AFPM Amit Langote wrote: > On Tue, Apr 21, 2026 at 9:57=E2=80=AFAM Richard Guo wrote: > > (maybe we should place the multi-line comment above the field.) > Makes sense. Perhaps we should also move the description of individual > fields, where needed, into the comment above the struct definition > like it is done for the nearby JsonValueExpr. Like this: This looks even better. I will take this approach. Thanks! - Richard