Fix JSON_ARRAY(query) empty set handling and view deparsing

Edit
ID 6628
Title Fix JSON_ARRAY(query) empty set handling and view deparsing
CI (CFBot) Summary
Stats (from CFBot) Patch version: v3, Patch count: 1, First patch: +355−69, All patches: +355−69
Tags Bugfix
Created 2026-03-31 06:39:08
Last modified 2026-03-31 06:39:08 (13 hours ago)
Latest email 2026-03-04 06:35:56 (3 weeks ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version stable
Authors Richard Guo (richardguo)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 <JSON value constructor>
First at 2026-02-26 09:57:50 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-03-04 06:35:56 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v3-0001-Fix-JSON_ARRAY-query-empty-set-handling-and-view-.patch) at 2026-03-04 06:35:56 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v3-0001-Fix-JSON_ARRAY-query-empty-set-handling-and-view-.patch) at 2026-03-04 06:35:56 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-JSON_ARRAY-query-empty-set-handling-and-view-.patch) at 2026-03-03 14:32:12 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-JSON_ARRAY-query-to-return-on-empty-sets.patch) at 2026-03-02 05:09:46 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
History
When Who What
2026-03-31 06:39:08 Richard Guo (richardguo) Attached mail thread 19418-591ba1f29862ef5b@postgresql.org
2026-03-31 06:39:08 Richard Guo (richardguo) Created patch record
Edit