Horton

Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 <JSON value constructor>

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Amit Langote <amitlangote09@gmail.com>, Vik Fearing <vik@postgresfriends.org>, lukas.eder@gmail.com, pgsql-bugs@lists.postgresql.org, Álvaro Herrera <alvherre@kurilemu.de>, Nathan Bossart <nathandbossart@gmail.com>, Heikki Linnakangas <hlinnaka@iki.fi>, Melanie Plageman <melanieplageman@gmail.com>
Date: 2026-04-24T12:04:03Z
Lists: pgsql-bugs 
On Thu, Apr 23, 2026 at 3:51 PM Michael Paquier <michael@paquier.xyz> 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

Commits

  1. Enforce RETURNING typmod for empty-set JSON_ARRAY(query)

  2. Fix JSON_ARRAY(query) empty set handling and view deparsing