Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1w0Qd7-001tfl-14
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 11 Mar 2026 20:58:09 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1w0Qd5-00BmMS-2O
	for pgsql-hackers@arkaria.postgresql.org;
	Wed, 11 Mar 2026 20:58:08 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <peter@eisentraut.org>)
	id 1w0Qd4-00BmMJ-2k
	for pgsql-hackers@lists.postgresql.org;
	Wed, 11 Mar 2026 20:58:07 +0000
Received: from fout-a7-smtp.messagingengine.com ([103.168.172.150])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <peter@eisentraut.org>)
	id 1w0Qd1-00000002CBR-2azs
	for pgsql-hackers@lists.postgresql.org;
	Wed, 11 Mar 2026 20:58:07 +0000
Received: from phl-compute-10.internal (phl-compute-10.internal [10.202.2.50])
	by mailfout.phl.internal (Postfix) with ESMTP id A3394EC025A;
	Wed, 11 Mar 2026 16:58:00 -0400 (EDT)
Received: from phl-frontend-03 ([10.202.2.162])
  by phl-compute-10.internal (MEProxy); Wed, 11 Mar 2026 16:58:00 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org;
	 h=cc:content-transfer-encoding:content-type:content-type:date
	:date:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm3; t=1773262680;
	 x=1773349080; bh=8Lzy7m7nnvE/CiJDrF/Yj9fGh7SjIUnYOR+vX9z6N1E=; b=
	T+Mi6l97Ke+mldPgJLHDuR9qjLdMpT6dvEUNgnb+/LTr5Gyjlg4Od5p7DSfVr8Iy
	PhCbL7T4R2VS1jlZyNyHxYC97KdDtMiXdae9K6Pq1GFAaNVSP9CLBjvSsD/qH6uq
	j8j1kMe3GuKiJn5zds8Jix7aKBoIG9GLtlbptH2cvEQ02NZJE68BfMr1lx+xKeRO
	p0sLH5nCUVEx+GM9+tCd67s8OCDFw8O591KSM44yeZU/HMRkwEU3r30GJNY4mr0r
	W/FSKr0bc9SVkxubOhCJtpli4e1sWkrXaF/A42p6yEDybDnyuzgUCdpm4YoHH1IY
	tpFg0KjOnHQyedk0MwwsAw==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-sender
	:x-me-sender:x-sasl-enc; s=fm1; t=1773262680; x=1773349080; bh=8
	Lzy7m7nnvE/CiJDrF/Yj9fGh7SjIUnYOR+vX9z6N1E=; b=vrNMI7fdlmNvaCoAQ
	or58i0mYnS+715MFROXLhtGicLq4XLkvqo9DOovwiy+E0s4NfJ0nWmru36epeNlh
	THXSxRzk/5KJBn963r+B8LACCkjZs5J7tqVxSSxIbIk6D/G7mtDCvm7WcsyzPtkC
	GLQUV8n0stkHhJ7Too/6h8foEckB8hq9bSySFnc9qxnLItDBh0VYN0lHISmHQ8l2
	cBLWQa3luvMTctPuqWEcXVqBjcT5ur4NYAIW1MfXsgMJ2l8Tfx3STyVuF7O5yjX4
	iy4d/1EUsoXfrloiOZ8dHIMXn1ETkNy0o1jn+roUa8S6kPU1CXzsSbgP/ts1b59O
	hM3gA==
X-ME-Sender: <xms:WNexaYYwwM8BhwF_MM0h-hwpGEVrf9O_j-vBOZ5eDyo8iSgwl1ESgg>
    <xme:WNexaZasiOiNuNWZ2vMXzJ0fhmX3JPgTqKbk8rbTE95ixUSMcHxF0lme7Ff77qYsw
    -3fkTYoF9q64Xm6d75sjv8raWUZj7PjrnhJ22siE9j8_xm6dw2N>
X-ME-Received: 
 <xmr:WNexaQk20S9jwmx_bcvOCSMmr6MNJu5bQvXqU7OMuENwd3fyB0U9v91fnvl77m6p8Td2aM5W5IJWHVactvA1DFiEJ_bN9R0>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvkeegledvucetufdoteggodetrf
    dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu
    rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf
    gurhepkfffgggfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomheprfgvthgvrhcu
    gfhishgvnhhtrhgruhhtuceophgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhgqeenuc
    ggtffrrghtthgvrhhnpeehiedvhfeuhfeugefgfeehgeejtdevuefhtefhueefvddugfdt
    ueehgfefudfhffenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfh
    hrohhmpehpvghtvghrsegvihhsvghnthhrrghuthdrohhrghdpnhgspghrtghpthhtohep
    vddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepphgrvhgvlhdrshhtvghhuhhlvg
    esghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehlihhs
    thhsrdhpohhsthhgrhgvshhqlhdrohhrgh
X-ME-Proxy: <xmx:WNexadxgxhhbTa6plyUgnQdiDlWQNa32qcggcy_OcykRKKtsHXA3Wg>
    <xmx:WNexaWNjE8Qj10y3W3_2yHEQvZxKkEg5YxQWF4y7y34Dzpfk1BEBuA>
    <xmx:WNexaZQuaP7faM034Yw4-_qBxQS2Hjt9pzIVbe8PQW4ucLJelDPvVA>
    <xmx:WNexacZ_ORBoDDkt_pKxrzB7kFcIKFQf5G2boiYZPNaKsJCoB2kiZw>
    <xmx:WNexabpCDKqtbha27ximj_ueLRVUi33yS__bvxR5ay4BsZAFsh-ldvu4>
Feedback-ID: ie0a040ee:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed,
 11 Mar 2026 16:57:59 -0400 (EDT)
Message-ID: <d626bc1a-e6c7-4bb5-9760-b4b119ca6196@eisentraut.org>
Date: Wed, 11 Mar 2026 21:57:58 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: POC: PLpgSQL FOREACH IN JSON ARRAY
To: Pavel Stehule <pavel.stehule@gmail.com>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: 
 <CAFj8pRD9Jjv+m=6DP6vWWn5NnZeTPH9eoPFCnA1JE5hRKRDMxQ@mail.gmail.com>
Content-Language: en-US
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: 
 <CAFj8pRD9Jjv+m=6DP6vWWn5NnZeTPH9eoPFCnA1JE5hRKRDMxQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/d626bc1a-e6c7-4bb5-9760-b4b119ca6196%40eisentraut.org>
Precedence: bulk

On 28.02.26 08:10, Pavel Stehule wrote:
> I wrote PoC for previously proposed plpgsql statement FOREACH IN JSON ARRAY

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?