Re: POC: PLpgSQL FOREACH IN JSON ARRAY
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: Pavel Stehule <pavel.stehule@gmail.com>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-03-12T04:30:11Z
Lists: pgsql-hackers
Peter Eisentraut <peter@eisentraut.org> writes: > Maybe this could be written in such a way that it doesn't hardcode JSON > arrays specifically, but a type could have an iteration helper function > that would feed this feature? +1. ISTM that this feature would make sense for subscriptable types, so one way to shoehorn it into the system without a lot of new overhead could be to extend struct SubscriptRoutines to offer optional support function(s) for iterating through all the elements of a subscriptable object. regards, tom lane