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-committers-owner+archive@lists.postgresql.org>)
	id 1rO1ht-000ZCo-EY
	for pgsql-committers@arkaria.postgresql.org; Thu, 11 Jan 2024 20:31:18 +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-committers-owner+archive@lists.postgresql.org>)
	id 1rO1hq-00EhYj-Rd
	for pgsql-committers@arkaria.postgresql.org; Thu, 11 Jan 2024 20:31:14 +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.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1rO1fi-00Ed2Y-Ab
	for pgsql-committers@lists.postgresql.org; Thu, 11 Jan 2024 20:29:02 +0000
Received: from mahout.postgresql.org ([2001:4800:3e1:1::227])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1rO1fb-0014We-4x
	for pgsql-committers@lists.postgresql.org; Thu, 11 Jan 2024 20:29:01 +0000
Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198])
	by mahout.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1rO1fY-003BIz-9W
	for pgsql-committers@lists.postgresql.org; Thu, 11 Jan 2024 20:28:53 +0000
Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org)
	by gemulon.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1rO1fY-000xb4-8D
	for pgsql-committers@lists.postgresql.org; Thu, 11 Jan 2024 20:28:52 +0000
Content-Type: multipart/mixed; boundary="===============2073722582653637134=="
MIME-Version: 1.0
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Allow subquery pullup to wrap a PlaceHolderVar in another one.
X-Auto-Response-Suppress: All
Auto-Submitted: auto-generated
Message-Id: <E1rO1fY-000xb4-8D@gemulon.postgresql.org>
Date: Thu, 11 Jan 2024 20:28:52 +0000
List-Id: <pgsql-committers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-committers@lists.postgresql.org>
List-Owner: <mailto:pgsql-committers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-committers>
Archived-At: 
 <https://www.postgresql.org/message-id/E1rO1fY-000xb4-8D%40gemulon.postgresql.org>
Precedence: bulk

--===============2073722582653637134==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64

QWxsb3cgc3VicXVlcnkgcHVsbHVwIHRvIHdyYXAgYSBQbGFjZUhvbGRlclZhciBpbiBhbm90aGVy
IG9uZS4KClRoZSBjb2RlIGZvciB3cmFwcGluZyBzdWJxdWVyeSBvdXRwdXQgZXhwcmVzc2lvbnMg
aW4gUGxhY2VIb2xkZXJWYXJzCmJlbGlldmVkIHRoYXQgaWYgdGhlIGV4cHJlc3Npb24gYWxyZWFk
eSB3YXMgYSBQbGFjZUhvbGRlclZhciwgaXQgd2FzCm5ldmVyIG5lY2Vzc2FyeSB0byB3cmFwIHRo
YXQgaW4gYW5vdGhlciBvbmUuICBUaGF0J3Mgd3JvbmcgaWYgdGhlCmV4cHJlc3Npb24gaXMgdW5k
ZXJuZWF0aCBhbiBvdXRlciBqb2luIGFuZCBpbnZvbHZlcyBhIGxhdGVyYWwKcmVmZXJlbmNlIHRv
IG91dHNpZGUgdGhhdCBzY29wZTogZmFpbGluZyB0byBhZGQgYW4gYWRkaXRpb25hbCBQSFYKcmlz
a3MgZXZhbHVhdGluZyB0aGUgZXhwcmVzc2lvbiBhdCB0aGUgd3JvbmcgcGxhY2UgYW5kIGhlbmNl
IG5vdApmb3JjaW5nIGl0IHRvIG51bGwgd2hlbiB0aGUgb3V0ZXIgam9pbiBzaG91bGQgZG8gc28u
ICBUaGlzIGlzIGFuCm92ZXJzaWdodCBpbiBjb21taXQgOWU3ZTI5Yzc1LCB3aGljaCBhZGRlZCBs
b2dpYyB0byBmb3JjaWJseSB3cmFwCmxhdGVyYWwtcmVmZXJlbmNlIFZhcnMgaW4gUGxhY2VIb2xk
ZXJWYXJzLCBidXQgZGlkbid0IHNlZSB0aGF0IHRoZQphZGphY2VudCBjYXNlIGZvciBQbGFjZUhv
bGRlclZhcnMgbmVlZGVkIHRoZSBzYW1lIHRyZWF0bWVudC4KClRoZSB0ZXN0IGNhc2Ugd2UgaGF2
ZSBmb3IgdGhpcyBkb2Vzbid0IGZhaWwgYmVmb3JlIDRiZTA1OGZlOSwgYnV0IG5vdwp0aGF0IEkg
c2VlIHRoZSBwcm9ibGVtIEkgd29uZGVyIGlmIGl0IGlzIHBvc3NpYmxlIHRvIGRlbW9uc3RyYXRl
CnJlbGF0ZWQgZXJyb3JzIGJlZm9yZSB0aGF0LiAgVGhhdCdzIG1vb3QgdGhvdWdoLCBzaW5jZSBh
bGwgc3VjaApicmFuY2hlcyBhcmUgb3V0IG9mIHN1cHBvcnQuCgpQZXIgYnVnICMxODI4NCBmcm9t
IEhvbGdlciBSZWlzZS4gIEJhY2stcGF0Y2ggdG8gYWxsIHN1cHBvcnRlZApicmFuY2hlcy4KCkRp
c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTgyODQtNDc1MDVhMjBjMjM2NDdmOEBwb3N0
Z3Jlc3FsLm9yZwoKQnJhbmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0K
aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9hMGI0ZmRhNDQyYTdhY2Yz
MWQ5MTlmNWE4OTg4ZDIzMGZhNGRiNmNiCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpz
cmMvYmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwam9pbnRyZWUuYyB8ICA5ICsrKysrKystLQpz
cmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4ub3V0ICAgICAgICB8IDI2ICsrKysrKysrKysr
KysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2pvaW4uc3FsICAgICAgICAgICAg
IHwgMTIgKysrKysrKysrKysrCjMgZmlsZXMgY2hhbmdlZCwgNDUgaW5zZXJ0aW9ucygrKSwgMiBk
ZWxldGlvbnMoLSkKCg==

--===============2073722582653637134==--