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 ) id 1vw4K9-000y65-16 for pgsql-committers@arkaria.postgresql.org; Fri, 27 Feb 2026 20:20:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vw4K7-006ZoF-1h for pgsql-committers@arkaria.postgresql.org; Fri, 27 Feb 2026 20:20:31 +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.96) (envelope-from ) id 1vw4K7-006Znv-0z for pgsql-committers@lists.postgresql.org; Fri, 27 Feb 2026 20:20:31 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vw4K4-00000001YhK-0zBf for pgsql-committers@lists.postgresql.org; Fri, 27 Feb 2026 20:20:30 +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.96) (envelope-from ) id 1vw4K4-004Vy8-1Z for pgsql-committers@lists.postgresql.org; Fri, 27 Feb 2026 20:20:28 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vw4K3-001S0r-0N for pgsql-committers@lists.postgresql.org; Fri, 27 Feb 2026 20:20:27 +0000 Content-Type: multipart/mixed; boundary="===============2117260279152943765==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Doc: improve user docs and code comments about EXISTS(SELECT * . X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 27 Feb 2026 20:20:27 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2117260279152943765== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RG9jOiBpbXByb3ZlIHVzZXIgZG9jcyBhbmQgY29kZSBjb21tZW50cyBhYm91dCBFWElTVFMoU0VM RUNUICogLi4uKS4KClBvaW50IG91dCB0aGF0IFBvc3RncmVzIGF1dG9tYXRpY2FsbHkgb3B0aW1p emVzIGF3YXkgdGhlIHRhcmdldCBsaXN0Cm9mIGFuIEVYSVNUUycgc3VicXVlcnksIGV4Y2VwdCBp biB3ZWlyZCBjYXNlcyBzdWNoIGFzIHRhcmdldCBsaXN0cwpjb250YWluaW5nIHNldC1yZXR1cm5p bmcgZnVuY3Rpb25zLiAgVGh1cywgYm90aCBjb21tb24gY29udmVudGlvbnMKRVhJU1RTKFNFTEVD VCAqIEZST00gLi4uKSBhbmQgRVhJU1RTKFNFTEVDVCAxIEZST00gLi4uKSBhcmUKb3ZlcmhlYWQt ZnJlZSBhbmQgdGhlcmUncyBsaXR0bGUgcmVhc29uIHRvIHByZWZlciBvbmUgb3ZlciB0aGUgb3Ro ZXIuCgpJbiB0aGUgY29kZSBjb21tZW50cywgbWVudGlvbiB0aGF0IHRoZSBTUUwgc3BlYyBzYXlz IHRoYXQKRVhJU1RTKFNFTEVDVCAqIEZST00gLi4uKSBzaG91bGQgYmUgaW50ZXJwcmV0ZWQgYXMg RVhJU1RTKFNFTEVDVApzb21lLWxpdGVyYWwgRlJPTSAuLi4pLCBidXQgd2UgZG9uJ3QgY2hvb3Nl IHRvIGRvIGl0IGV4YWN0bHkgdGhhdCB3YXkuCgpBdXRob3I6IFBldGVyIEVpc2VudHJhdXQgPHBl dGVyQGVpc2VudHJhdXQub3JnPgpSZXZpZXdlZC1ieTogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBh LnVzPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzliMzAxYzcwLTM5MDktNGYwZi05 OGNhLTllM2M0ZDE0MmYzZUBlaXNlbnRyYXV0Lm9yZwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRl dGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzY1 YTNmZjhmMWJlMDE4NmE5YzIwNzgyMWJjZjBmNTQzNTQ1YTA0ZDkKCk1vZGlmaWVkIEZpbGVzCi0t LS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9mdW5jL2Z1bmMtc3VicXVlcnkuc2dtbCAgIHwgMTAg KysrKysrKystLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9zdWJzZWxlY3QuYyB8ICA4ICsr KysrKystCjIgZmlsZXMgY2hhbmdlZCwgMTUgaW5zZXJ0aW9ucygrKSwgMyBkZWxldGlvbnMoLSkK Cg== --===============2117260279152943765==--