POC: PLpgSQL FOREACH IN JSON ARRAY

Edit
ID 6557
Title POC: PLpgSQL FOREACH IN JSON ARRAY
CI (CFBot) Summary
Stats (from CFBot) Patch version: v20260803, Patch count: 1, First patch: +1081−96, All patches: +1081−96
Tags PL/pgSQL
Created 2026-03-01 05:47:22
Last modified 2026-08-01 00:00:08 (1 week ago)
Latest email 2026-08-03 06:07:14 (5 days ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version
Authors Pavel Stehule (okbobcz)
Reviewers Tom Lane (tgl), Jim Jones (jimus) Become reviewer
Committer
Links
Emails
POC: PLpgSQL FOREACH IN JSON ARRAY
First at 2026-02-28 07:10:53 by Pavel Stehule <pavel.stehule at gmail.com>
Latest at 2026-08-03 06:07:14 by Pavel Stehule <pavel.stehule at gmail.com>
Latest attachment (v20260803-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-08-03 06:07:14 from Pavel Stehule <pavel.stehule at gmail.com>
    Attachment (v20260803-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-08-03 06:07:14 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: No)
    Attachment (v20260727-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-07-27 14:09:45 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: No)
    Attachment (foreach-benchmark.tar.gz.nocfbot) at 2026-07-23 18:07:07 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (v20260708-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-07-08 12:44:38 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260707-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-07-07 20:03:47 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260705-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-07-05 15:36:18 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260616-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-06-16 07:52:59 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260526-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-05-26 06:51:41 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260321-8-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-03-21 18:40:06 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260317-7-0001-FOREACH-scalar-IN-ARRAY-jsonb_expr.patch) at 2026-03-17 06:58:20 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260312-6-0001-FOREACH-scalar-IN-JSON-ARRAY.patch) at 2026-03-12 10:38:11 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260304-5-0001-FOREACH-scalar-IN-JSON-ARRAY.patch) at 2026-03-04 18:50:34 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260303-4-0001-FOREACH-scalar-IN-JSON-ARRAY.patch) at 2026-03-03 13:45:07 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260301-3-0001-FOREACH-scalar-IN-JSON-ARRAY.patch) at 2026-03-01 19:40:24 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260301-2-0001-FOREACH-scalar-IN-JSON-ARRAY.patch) at 2026-03-01 05:44:17 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (v20260228-1-0001-FOREACH-scalar-IN-JSON-ARRAY.patch) at 2026-02-28 07:10:53 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
History
When Who What
2026-08-01 00:00:08 CFbot Moved from CF PG20-1 to CF PG20-2
2026-03-17 19:34:24 Pavel Stehule (okbobcz) New status: Needs review
2026-03-15 19:50:21 Tom Lane (tgl) New status: Waiting on Author
2026-03-15 19:50:14 Tom Lane (tgl) Added tgl as reviewer
2026-03-09 06:11:45 Shreeya Sharma (shreeya2304) Posted review with messageid <177303670555.1094603.13924191747968426091.pgcf@coridan.postgresql.org>
2026-03-09 06:11:45 Shreeya Sharma (shreeya2304) New status: Ready for Committer
2026-03-09 06:03:27 Shreeya Sharma (shreeya2304) Posted comment with messageid <177303620797.1094603.15997516733973416614.pgcf@coridan.postgresql.org>
2026-03-05 16:50:28 Jim Jones (jimus) Added jimus as reviewer
2026-03-01 05:47:22 Pavel Stehule (okbobcz) Attached mail thread CAFj8pRD9Jjv+m=6DP6vWWn5NnZeTPH9eoPFCnA1JE5hRKRDMxQ@mail.gmail.com
2026-03-01 05:47:22 Pavel Stehule (okbobcz) Created patch record
Edit