Feedback-ID: i0fe9450f:Fastmail
Date: Wed, 19 Mar 2025 08:56:54 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Daniel Verite <daniel@manitou-mail.org>
Cc: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>,
	Jelte Fennema-Nio <postgres@jeltef.nl>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Add Pipelining support in psql
Message-ID: <Z9oIRs2c7SCTNmfi@paquier.xyz>
References: 
 <CAO6_Xqq4JEHRaGyC=r+dpi0Ejbp2P3aUo-KfR2NuipCvE-o_ZA@mail.gmail.com>
 <9aa66158-13c3-4f57-8367-ddf6f392fca7@manitou-mail.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="FyG0dTx7R4UbOHlf"
Content-Disposition: inline
In-Reply-To: <9aa66158-13c3-4f57-8367-ddf6f392fca7@manitou-mail.org>
Archived-At: 
 <https://www.postgresql.org/message-id/Z9oIRs2c7SCTNmfi%40paquier.xyz>
Precedence: bulk


--FyG0dTx7R4UbOHlf
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Mar 18, 2025 at 10:36:28AM +0100, Daniel Verite wrote:
> It's actually possible to use parameters
>=20
> \startpipeline=20
> \bind 'foo'
> select $1;
> \endpipeline
>=20
>  ?column?=20
> ----------
>  foo
> (1 row)
>=20
> I suspect there's a misunderstanding that \bind can only be placed
> after the query, because it's always written like that in the regression
> tests, and in the documentation.
> But that's just a notational preference.

Nice trick, unrelated to pipelines.  I don't think that we have
anything testing this specific pattern for \bind.  At quick glance all
our test use \bind at the end of a query string.  Perhaps we should?
--
Michael

--FyG0dTx7R4UbOHlf
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmfaCEYACgkQnvQgOdby
QH20jQ//WsI7b2BZujDveVVZgZKvRco4Geyz0q1aAWFaRnXzARh9Re9HqiE+5Ikp
tSbhQv2MbifCoEfByzTVVfazGL7ZFOYl34yApFVLP3EpfR2nxYy8Bd9Qxn1/5y4c
RZvFTXHC0lEb92i1nWLCEHoZSKEPRARdOO+11Bxj+9BBEnqDJPLxFo/a1WVIu1kf
3WuHCC4Q8X76Uen7pUluPfJZ+T9KYzNCWaxdoA4VccLylb4qtJseHNe+mSYDeqm2
7iZSL8ayfkLq90LL2hs+cCqTH1tAcg017USNqJW+QxyS7jAGPBigC13/h25gSkP7
e5aEZQzHxUctmRPLWyYvf+/nNXBC1oo0DFJzleWXn0yhvEnyItgnQWd0TUbM0yiy
j4/8uLKgcjB/FdDl2Yx5TPa/WVWR1xFgnTFKVpwbni5Gk1oVsZDrv+7AL37vcQo7
S4eTogc6++NNwG0YRDIDYQdZiUqfumfsVmRCF0+uNdydCXsS1fFq4CKF4QpAeuJc
kBlAFFCG6w82wEsPgzcrH7zWMGa+pnG1NTJz0dBbBFzdJqp7+5g4NEp0VPqAimVB
Q93d0PfyX2sNogzedHWrs56ZgFrTxbLdVMQc776sQ3AbTPymj1G9j47D5XriZvsR
MVdsCBucFbWX00k6lbXYGW8fChCt32zJqa1qw8Aqd9HSArKsyus=
=6FA7
-----END PGP SIGNATURE-----

--FyG0dTx7R4UbOHlf--