SQL/JSON json_table PLAN clause

Edit
ID 5478
Title SQL/JSON json_table PLAN clause
CI (CFBot) Summary
Stats (from CFBot) Patch version: v4, Patch count: 6, First patch: +44−15, All patches: +196−89
Tags Performance SQL Commands
Created 2024-12-30 22:07:46
Last modified 2026-07-14 21:53:45 (12 hours ago)
Latest email 2026-07-14 22:31:46 (12 hours ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Committed
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
Target version 20
Authors Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Andrew Dunstan (adunstan), Amit Langote (amitlan), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg), Anton Melnikov (antonmel), Nikita Malakhov (nmalakh)
Reviewers Amit Langote (amitlan), Vladlen Popolitov (vladlenpopolitov) Become reviewer
Committer Alexander Korotkov (smagen)
Links
Emails
SQL/JSON json_table plan clause
First at 2024-12-17 15:11:02 by Nikita Malakhov <hukutoc at gmail.com>
Latest at 2026-07-14 22:31:46 by Alexander Korotkov <aekorotkov at gmail.com>
Latest attachment (v4-0003-Make-JSON_TABLE-generated-path-names-avoid-collis.patch) at 2026-07-12 17:17:20 from Alexander Korotkov <aekorotkov at gmail.com>
    Attachment (v4-0003-Make-JSON_TABLE-generated-path-names-avoid-collis.patch) at 2026-07-12 17:17:20 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Revert-cascading-of-JSON_TABLE-s-ON-ERROR.patch) at 2026-07-11 12:18:56 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v2-0004-Fix-and-polish-JSON_TABLE-documentation.patch) at 2026-07-10 16:27:46 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (func-json-plan-doc-fixes.patch) at 2026-07-10 15:47:35 from Thom Brown <thom at linux.com> (Patch: Yes)
    Attachment (v1-0003-Make-JSON_TABLE-generated-path-names-avoid-collis.patch) at 2026-07-09 19:52:20 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v25-0001-JSON_TABLE-PLAN-clause.patch) at 2026-07-07 23:38:56 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v24-0001-JSON_TABLE-PLAN-Clause-1-3.patch) at 2026-07-04 21:02:40 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v23-0001-json-table-plan-clause.patch) at 2026-05-15 11:53:14 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v22-0002-JSON-TABLE-PLAN-clause.patch) at 2026-03-16 16:30:16 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v21-0002-JSON-TABLE-PLAN-clause.patch) at 2025-12-22 15:11:20 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v20-0001-JSON-TABLE-PLAN-clause.patch) at 2025-04-11 18:57:05 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v19-0001-JSON-TABLE-PLAN-clause.patch) at 2025-02-02 19:43:43 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v18-0001-JSON-TABLE-PLAN-clause.patch) at 2024-12-17 15:11:02 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
History
When Who What
2026-07-14 21:53:45 Alexander Korotkov (smagen) Closed in commitfest PG20-1 with status: Committed
2026-07-14 21:53:40 Alexander Korotkov (smagen) Added smagen as committer
2026-07-14 21:53:36 Alexander Korotkov (smagen) Changed tags to Performance, SQL Commands
2026-07-14 21:53:36 Alexander Korotkov (smagen) Changed targetversion to 20
2026-07-10 16:32:38 CFbot Patch does not need rebase anymore
2026-07-10 16:07:26 CFbot Patch needs rebase
2026-05-15 12:11:31 CFbot Patch does not need rebase anymore
2026-04-18 03:40:25 CFbot Patch needs rebase
2026-03-31 19:58:42 Andrew Dunstan (adunstan) Moved from CF PG19-3 to CF PG20-1
2025-10-20 14:31:42 Andrew Dunstan (adunstan) Moved from CF PG19-2 to CF PG19-3
2025-08-29 14:15:54 Nikita Malakhov (nmalakh) Moved from CF PG19-1 to CF PG19-2
2025-04-13 18:08:43 Nikita Malakhov (nmalakh) Closed in commitfest 2025-03 with status: Moved to next CF
2025-02-26 15:31:52 Andrew Dunstan (adunstan) Closed in commitfest 2025-01 with status: Moved to next CF
2025-01-16 09:18:04 Vladlen Popolitov (vladlenpopolitov) Posted review with messageid <173701908440.618.6142516465224329594.pgcf@coridan.postgresql.org>
2025-01-16 09:14:10 Vladlen Popolitov (vladlenpopolitov) Added vladlenpopolitov as reviewer
2024-12-30 22:10:31 Nikita Malakhov (nmalakh) Changed reviewers to Amit Langote (amitlan)
2024-12-30 22:10:31 Nikita Malakhov (nmalakh) Changed authors to Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Andrew Dunstan (adunstan), Amit Langote (amitlan), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg), Anton Melnikov (antonmel), Nikita Malakhov (nmalakh)
2024-12-30 22:10:31 Nikita Malakhov (nmalakh) Changed targetversion to 18
2024-12-30 22:07:46 Nikita Malakhov (nmalakh) Attached mail thread CAN-LCVP7HXmGu-WcinsHvdKqMGEdv=1Y67H4U58F6Y=Q0M5GyQ@mail.gmail.com
2024-12-30 22:07:46 Nikita Malakhov (nmalakh) Created patch record
Edit