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.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tf1un-00H33D-Cl
	for pgsql-hackers@arkaria.postgresql.org; Mon, 03 Feb 2025 19:15:26 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tf1ul-00G6Mq-Cf
	for pgsql-hackers@arkaria.postgresql.org; Mon, 03 Feb 2025 19:15:23 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <x4mmm@yandex-team.ru>)
	id 1tf1uk-00G6Mi-UJ
	for pgsql-hackers@lists.postgresql.org; Mon, 03 Feb 2025 19:15:23 +0000
Received: from forwardcorp1d.mail.yandex.net ([178.154.239.200])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <x4mmm@yandex-team.ru>)
	id 1tf1ug-002zf3-1b
	for pgsql-hackers@lists.postgresql.org;
	Mon, 03 Feb 2025 19:15:21 +0000
Received: from mail-nwsmtp-smtp-corp-main-80.iva.yp-c.yandex.net (mail-nwsmtp-smtp-corp-main-80.iva.yp-c.yandex.net [IPv6:2a02:6b8:c0c:4310:0:640:bf36:0])
	by forwardcorp1d.mail.yandex.net (Yandex) with ESMTPS id 4CD1E60B2D;
	Mon,  3 Feb 2025 22:15:14 +0300 (MSK)
Received: from smtpclient.apple (unknown [2a02:6b8:b081:225::1:1d])
	by mail-nwsmtp-smtp-corp-main-80.iva.yp-c.yandex.net (smtpcorp/Yandex) with ESMTPSA id CFpW752IWa60-6F1iQXn5;
	Mon, 03 Feb 2025 22:15:13 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru;
	s=default; t=1738610113;
	bh=9eU4/P89ZVtB8m0kbIcHCknw8DDjkmV/TJPzbDvd8bQ=;
	h=Message-Id:To:Date:References:Cc:In-Reply-To:From:Subject;
	b=MAHKPsjJ3scupsnqOmFwvNXGnIk6pVIzCU47kshE0rN46GH/TSGNRTPHrJB6/w2Iy
	 YozisCUqPL+7vasgMbZSl//xUaeS03Q6UnWQ3Q3k3+cmqTy79bw8IRZG+dkIbAVUwA
	 Xdic6/M+PLsRZKnXVrzb5pUg8J5bWi8ZfyVGksGM=
Authentication-Results: mail-nwsmtp-smtp-corp-main-80.iva.yp-c.yandex.net; dkim=pass header.i=@yandex-team.ru
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: Using Expanded Objects other than Arrays from plpgsql
From: Andrey Borodin <x4mmm@yandex-team.ru>
In-Reply-To: <416464.1738606690@sss.pgh.pa.us>
Date: Tue, 4 Feb 2025 00:15:02 +0500
Cc: Pavel Borisov <pashkin.elfe@gmail.com>,
 Michel Pelletier <pelletier.michel@gmail.com>,
 Pavel Stehule <pavel.stehule@gmail.com>,
 pgsql-hackers@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <729D43DE-BCA0-495E-926E-8789A01DACC4@yandex-team.ru>
References: <CACxu=vJaKFNsYxooSnW1wEgsAO5u_v1XYBacfVJ14wgJV_PYeg@mail.gmail.com>
 <1342498.1729444411@sss.pgh.pa.us>
 <CACxu=vLXvpzN4X3k+9jsMt6ujuOvFVUSkA80t_cROSsF4y2jQQ@mail.gmail.com>
 <1445998.1729482404@sss.pgh.pa.us>
 <CACxu=vKEF8Qa-OaADFxf0uMg-xw6gH_CNCWd2s+xaqh-gY4=xg@mail.gmail.com>
 <2062830.1729625620@sss.pgh.pa.us> <2265411.1729699470@sss.pgh.pa.us>
 <CACxu=v++HNmss59yGUDkRny7g=M8tZ2YXF07AUXqKVGqcSfxGQ@mail.gmail.com>
 <2354718.1729737539@sss.pgh.pa.us> <2581216.1729794746@sss.pgh.pa.us>
 <CACxu=v+dn37zr8gx5xNP-EZY3OLtGLTHrbx_ZkCQc40HpyMLKA@mail.gmail.com>
 <1948345.1730500073@sss.pgh.pa.us>
 <CACxu=vL7i_U_iSNpREe8eCAMEyKHuPpk9THRpBhk+ar0U1EdOw@mail.gmail.com>
 <CACxu=vKLc6f5N8_DR58LKkE1eohWSxTvThTeGsLm7p7QH1aFBA@mail.gmail.com>
 <CACxu=vJf2S=ysun_h=zmYNu6oUM47+egbpX5mMC0X9BJK=EQwQ@mail.gmail.com>
 <CACxu=vK+S6BXN8ZYyBvqQBWrcwHXqtue1-ZuKO3+XtHGBYcDUQ@mail.gmail.com>
 <CAFj8pRCd6xcH-AYEyHFdGdU89O9JjZ-v-pyQnOwd9zNJkCEdhQ@mail.gmail.com>
 <3797606.1732045516@sss.pgh.pa.us> <CACxu=! ! ! !
 vJ1UeXPjPOzfT2E=tFpSCxPxcB7hgfqHYmefJWh3ZXPew@mail.gmail.com>
 <1417389.1736964543@sss.pgh.pa.us>
 <CACxu=vKModwqSpEjpn-ur1uMAEYkcd-i8CvNsH-z9=dk7F7YQw@mail.gmail.com>
 <3363452.1737483125@sss.pgh.pa.us>
 <0AC229FA-A3F1-43FD-B0DC-A46A73FEAFF7@yandex-team.ru>
 <931398.1737905825@sss.pgh.pa.us>
 <38A31221-C1C4-4846-9709-D66ACD76E87A@yandex-team.ru>
 <46876.1737918281@sss.pgh.pa.us>
 <CALT9ZEGy5+GNQUtR80BPL7k-Qi47sqwPLnN_dOaQUW5UbxcTGA@mail.gmail.com>
 <3682021.1738288421@sss.pgh.pa.us> <256915.1738533419@sss.pgh.pa.us>
 <932C9840-63D6-469D-9C65-1B1A14594D29@yandex-team.ru>
 <412280.1738604208@sss.pgh.pa.us>
 <5AAA4DBE-4CC2-4D22-B138-BF2D48AE096F@yandex-team.ru>
 <416464.1738606690@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
X-Mailer: Apple Mail (2.3776.700.51.11.1)
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/729D43DE-BCA0-495E-926E-8789A01DACC4%40yandex-team.ru>
Precedence: bulk



> On 3 Feb 2025, at 23:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> But I don't want to think of
> EEOP_PARAM_CALLBACK as being specifically tied to PL/pgSQL.

I've found 1 users on Github [0]. And a lot of copied code like [1]. And =
there might be some unindexed cases.
Let's keep paramarg2.


Best regards, Andrey Borodin.
[0] =
https://github.com/wanglinn/xadb/blob/7695b7edcb0a89f3173b648c0da5b953538f=
2aa9/src/backend/pgxc/pool/execRemote.c#L835
[1] =
https://github.com/babelfish-for-postgresql/babelfish_extensions/blob/376c=
f488804fa02f9b1db5bbfbe74e98627fe96c/contrib/babelfishpg_tsql/src/pl_exec.=
c#L8030=