MIME-Version: 1.0
References: 
 <CAFj8pRD9Jjv+m=6DP6vWWn5NnZeTPH9eoPFCnA1JE5hRKRDMxQ@mail.gmail.com>
 <d626bc1a-e6c7-4bb5-9760-b4b119ca6196@eisentraut.org>
 <4166.1773289811@sss.pgh.pa.us>
In-Reply-To: <4166.1773289811@sss.pgh.pa.us>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Thu, 12 Mar 2026 08:00:19 +0100
Message-ID: 
 <CAFj8pRDom7DWYnOWUtSArW2D=WJ+JKpU=oNPgO7C=KUU_pEb-w@mail.gmail.com>
Subject: Re: POC: PLpgSQL FOREACH IN JSON ARRAY
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter@eisentraut.org>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000679d38064cce5042"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFj8pRDom7DWYnOWUtSArW2D%3DWJ%2BJKpU%3DoNPgO7C%3DKUU_pEb-w%40mail.gmail.com>
Precedence: bulk

--000000000000679d38064cce5042
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

=C4=8Dt 12. 3. 2026 v 5:30 odes=C3=ADlatel Tom Lane <tgl@sss.pgh.pa.us> nap=
sal:

> 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.
>

I'll try to write second patch in this way

Regards

Pavel


>
>                         regards, tom lane
>

--000000000000679d38064cce5042
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi</div><br><div class=3D"gmail_quote gmail_quote_con=
tainer"><div dir=3D"ltr" class=3D"gmail_attr">=C4=8Dt 12. 3. 2026 v=C2=A05:=
30 odes=C3=ADlatel Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@ss=
s.pgh.pa.us</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-left:1ex">Peter Eisentraut &lt;<a href=3D"mailto:peter@eisentraut.org" ta=
rget=3D"_blank">peter@eisentraut.org</a>&gt; writes:<br>
&gt; Maybe this could be written in such a way that it doesn&#39;t hardcode=
 JSON <br>
&gt; arrays specifically, but a type could have an iteration helper functio=
n <br>
&gt; that would feed this feature?<br>
<br>
+1.=C2=A0 ISTM that this feature would make sense for subscriptable types,<=
br>
so one way to shoehorn it into the system without a lot of new overhead<br>
could be to extend struct SubscriptRoutines to offer optional support<br>
function(s) for iterating through all the elements of a subscriptable<br>
object.<br></blockquote><br></div><div class=3D"gmail_quote gmail_quote_con=
tainer">I&#39;ll try to write second patch in this way</div><div class=3D"g=
mail_quote gmail_quote_container"><br></div><div class=3D"gmail_quote gmail=
_quote_container">Regards</div><div class=3D"gmail_quote gmail_quote_contai=
ner"><br></div><div class=3D"gmail_quote gmail_quote_container">Pavel</div>=
<div class=3D"gmail_quote gmail_quote_container"><div>=C2=A0</div><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex">
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div></div>

--000000000000679d38064cce5042--