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 ) id 1uAwoI-004OjG-Su for pgsql-committers@arkaria.postgresql.org; Fri, 02 May 2025 20:16:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uAwoF-00BRVQ-Al for pgsql-committers@arkaria.postgresql.org; Fri, 02 May 2025 20:16:36 +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 ) id 1uAwoF-00BRUF-3U for pgsql-committers@lists.postgresql.org; Fri, 02 May 2025 20:16:36 +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.96) (envelope-from ) id 1uAwoD-000k76-34 for pgsql-committers@lists.postgresql.org; Fri, 02 May 2025 20:16:35 +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 ) id 1uAwoC-0090w1-9M for pgsql-committers@lists.postgresql.org; Fri, 02 May 2025 20:16:33 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uAwoC-000fkH-27 for pgsql-committers@lists.postgresql.org; Fri, 02 May 2025 20:16:32 +0000 Content-Type: multipart/mixed; boundary="===============5341412645515044170==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Don't use a tuplestore if we don't have to for SQL-language func X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 02 May 2025 20:16:32 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5341412645515044170== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RG9uJ3QgdXNlIGEgdHVwbGVzdG9yZSBpZiB3ZSBkb24ndCBoYXZlIHRvIGZvciBTUUwtbGFuZ3Vh Z2UgZnVuY3Rpb25zLgoKV2Ugb25seSBuZWVkIGEgdHVwbGVzdG9yZSBpZiB3ZSdyZSBhY3R1YWxs eSBnb2luZyB0byBhY2N1bXVsYXRlCm11bHRpcGxlIHJlc3VsdCB0dXBsZXMuICBPYnZpb3VzbHkg dGhlbiB3ZSBkb24ndCBuZWVkIG9uZSBmb3Igbm9uLXNldC0KcmV0dXJuaW5nIGZ1bmN0aW9uczsg YnV0IGV2ZW4gYSBTUkYgZG9lc24ndCBuZWVkIG9uZSBpZiB3ZSBkZWNpZGUgdG8KdXNlICJsYXp5 RXZhbCIgKG9uZSByb3cgYXQgYSB0aW1lKSBtb2RlLiAgSW4gdGhlc2UgY2FzZXMsIGl0J3MKc3Vm ZmljaWVudCB0byB1c2UgdGhlIGp1bmtmaWx0ZXIncyByZXN1bHQgc2xvdCB0byBob2xkIHRoZSBz aW5nbGUgcm93CnRoYXQncyBkdWUgdG8gYmUgcmV0dXJuZWQuICBXZSBqdXN0IG5lZWQgdG8gIm1h dGVyaWFsaXplIiB0aGF0IHNsb3QKdG8gZW5zdXJlIGl0IGhvbGRzIG9udG8gdGhlIGRhdGEgcGFz dCBzaHV0ZG93biBvZiB0aGUgc3ViLWV4ZWN1dG9yLgoKVGhlIG9yaWdpbmFsIGludGVudCBvZiB0 aGlzIHBhdGNoIHdhcyBwYXJ0aWFsbHkgdG8gc2F2ZSBhIGZldyBjeWNsZXMKKGJ5IG5vdCBwdXR0 aW5nIHR1cGxlcyBpbnRvIGEgdHVwbGVzdG9yZSBvbmx5IHRvIHB1bGwgdGhlbSBiYWNrIG91dApp bW1lZGlhdGVseSksIGJ1dCBtb3N0bHkgdG8gZW5zdXJlIHRoYXQgd2UgZG9uJ3QgdXNlIGEgdHVw bGVzdG9yZQppbiBub24tc2V0LXJldHVybmluZyBmdW5jdGlvbnMuICBUaGF0J3MgYmVjYXVzZSBJ IGhhZCBjb25jZXJucwphYm91dCB3aGV0aGVyIGEgdHVwbGVzdG9yZSBpcyBzYWZlIHRvIGtlZXAg YWNyb3NzIHF1ZXJpZXMsCndoaWNoIHdhcyBwb3NzaWJsZSBmb3IgZnVuY3Rpb25zIGludm9rZWQg dmlhIGxvbmctbGl2ZWQgRm1nckluZm9zCnN1Y2ggYXMgdGhvc2Uga2VwdCBpbiB0aGUgdHlwY2Fj aGUuICBUaGVyZSBhcmUgbm8gY2FzZXMgd2hlcmUgU1JGcwphcmUgY2FsbGVkIHRoYXQgd2F5LCBz byBnZXR0aW5nIHJpZCBvZiB0aGUgdHVwbGVzdG9yZSBpbiBub24tU1JGcwpzaG91bGQgbWFrZSB0 aGluZ3Mgc2FmZXIuCgpIb3dldmVyLCBpdCBlbWVyZ2VzIHRoYXQgcnVubmluZyBmbWdyX3NxbCBp biBhIHNob3J0LWxpdmVkIGNvbnRleHQKKGFzIDU5NWQxZWZlZCBtYWRlIGl0IGRvKSBtYWtlcyB0 aGUgZXhpc3RpbmcgY29kaW5nIHVuc2FmZSBhbnl3YXk6CndlIGNhbiBlbmQgdXAgd2l0aCBhIGxv bmctbGl2ZWQgVHVwbGVUYWJsZVNsb3QgaG9sZGluZyBhIGZyZWVhYmxlCnJlZmVyZW5jZSB0byBh IHNob3J0LWxpdmVkIHR1cGxlLCByZXN1bHRpbmcgaW4gYSBkb3VibGUtZnJlZSBjcmFzaC4KTm90 IHRyeWluZyB0byBwdWxsIHR1cGxlcyBvdXQgb2YgdGhlIHR1cGxlc3RvcmUgdXNpbmcgdGhhdCBz bG90CmRvZGdlcyB0aGUgcHJvYmxlbSwgc28gSSdtIGdvaW5nIHRvIGNvbW1pdCB0aGlzIG5vdyBy YXRoZXIgdGhhbgppbnZlbnQgYSBiYW5kLWFpZCBzb2x1dGlvbiBmb3IgdjE4LgoKUmVwb3J0ZWQt Ynk6IEFsZXhhbmRlciBMYWtoaW4gPGV4Y2x1c2lvbkBnbWFpbC5jb20+CkF1dGhvcjogVG9tIExh bmUgPHRnbEBzc3MucGdoLnBhLnVzPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzI0 NDM1MzIuMTc0NDkxOTk2OEBzc3MucGdoLnBhLnVzCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdy LmVzL20vOWY5NzU4MDMtMWExYy00ZjIxLWI5ODctZjU3MmUxMTBlODYwQGdtYWlsLmNvbQoKQnJh bmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3Fs Lm9yZy9wZy9jb21taXRkaWZmL2U4M2E4YWU0NDcyOWJmZGQxNWQzMTEwMWJkMmM5OWJlOThjZmM2 OTEKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2Z1 bmN0aW9ucy5jIHwgMTM1ICsrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLQox IGZpbGUgY2hhbmdlZCwgODUgaW5zZXJ0aW9ucygrKSwgNTAgZGVsZXRpb25zKC0pCgo= --===============5341412645515044170==--