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 1w3iGI-001Tms-0o for pgsql-committers@arkaria.postgresql.org; Fri, 20 Mar 2026 22:24:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3iGE-008M4m-1U for pgsql-committers@arkaria.postgresql.org; Fri, 20 Mar 2026 22:24:06 +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.96) (envelope-from ) id 1w3iGE-008M4d-0o for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 22:24:06 +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.98.2) (envelope-from ) id 1w3iG6-00000000FZX-2cpZ for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 22:24: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.96) (envelope-from ) id 1w3iG0-0029xJ-2i for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 22:23:53 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3iFz-000hor-1A for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 22:23:52 +0000 Content-Type: multipart/mixed; boundary="===============3420134121690507240==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: plpgsql: optimize "SELECT simple-expression INTO var". X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 20 Mar 2026 22:23:52 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3420134121690507240== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 cGxwZ3NxbDogb3B0aW1pemUgIlNFTEVDVCBzaW1wbGUtZXhwcmVzc2lvbiBJTlRPIHZhciIuCgpQ cmV2aW91c2x5LCB3ZSBhbHdheXMgZmVkIFNFTEVDVCAuLi4gSU5UTyB0byB0aGUgU1BJIG1hY2hp bmVyeS4KV2hpbGUgdGhhdCB3b3JrcyBmb3IgYWxsIGNhc2VzLCBpdCdzIGEgZ3JlYXQgZGVhbCBz bG93ZXIgdGhhbgp0aGUgb3RoZXJ3aXNlLWVxdWl2YWxlbnQgInZhciA6PSBleHByZXNzaW9uIiBp ZiB0aGUgZXhwcmVzc2lvbgppcyAic2ltcGxlIiBhbmQgdGhlIElOVE8gdGFyZ2V0IGlzIGEgc2lu Z2xlIHZhcmlhYmxlLiAgVXNlcnMKY29taW5nIGZyb20gTVNTUUwgb3IgVF9TUUwgYXJlIGxpa2Vs eSB0byBiZSBzdXJwcmlzZWQgYnkgdGhpczsKdGhleSBhcmUgdXNlZCB0byB3cml0aW5nIFNFTEVD VCAuLi4gSU5UTyBzaW5jZSB0aGVyZSBpcyBubwoidmFyIDo9IGV4cHJlc3Npb24iIHN5bnRheCBp biB0aG9zZSBkaWFsZWN0cy4gIEhlbmNlLCBjaGVjayBmb3IKYSBzaW1wbGUgZXhwcmVzc2lvbiBh bmQgdXNlIHRoZSBmYXN0ZXIgY29kZSBwYXRoIGlmIHBvc3NpYmxlLgoKKEhlcmUsICJzaW1wbGUi IG1lYW5zIHdoYXRldmVyIGV4ZWNfaXNfc2ltcGxlX3F1ZXJ5IGFjY2VwdHMsCndoaWNoIGJhc2lj YWxseSBtZWFucyAiU0VMRUNUIHNjYWxhci1leHByZXNzaW9uIiB3aXRob3V0IGFueQppbnB1dCB0 YWJsZXMsIGFnZ3JlZ2F0ZXMsIHF1YWwgY2xhdXNlcywgZXRjLikKClRoaXMgb3B0aW1pemF0aW9u IGlzIG5vdCBlbnRpcmVseSB0cmFuc3BhcmVudC4gIE5vdGFibHksIG9uZSBvZgp0aGUgcmVhc29u cyBpdCdzIGZhc3RlciBpcyB0aGF0IHRoZSBob29rcyB0aGF0IHBnX3N0YXRfc3RhdGVtZW50cwp1 c2VzIGFyZW4ndCBjYWxsZWQgaW4gdGhpcyBwYXRoLCBzbyB0aGF0IHRoZSBldmFsdWF0ZWQgZXhw cmVzc2lvbgpubyBsb25nZXIgYXBwZWFycyBpbiBwZ19zdGF0X3N0YXRlbWVudHMgb3V0cHV0IGFz IGl0IGRpZCBiZWZvcmUuClRoZXJlIG1heSBiZSBzb21lIG90aGVyIG1pbm9yIGJlaGF2aW9yYWwg Y2hhbmdlcyB0b28sIGFsdGhvdWdoCkkgdHJpZWQgaGFyZCB0byBtYWtlIGVycm9yIHJlcG9ydGlu ZyBsb29rIHRoZSBzYW1lLiAgSG9wZWZ1bGx5LApub25lIG9mIHRoZW0gYXJlIHNpZ25pZmljYW50 IGVub3VnaCB0byBub3QgYmUgYWNjZXB0YWJsZSBhcwpyb3V0aW5lIGNoYW5nZXMgaW4gYSBQRyBt YWpvciB2ZXJzaW9uLgoKQXV0aG9yOiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+ClJldmll d2VkLWJ5OiBQYXZlbCBTdGVodWxlIDxwYXZlbC5zdGVodWxlQGdtYWlsLmNvbT4KRGlzY3Vzc2lv bjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUZqOHBSRGllU1FPUERIRF9zdnZSNzU4NzV1UmVqUzlj Tjg3Rm9BQzNpWE1YUzFzYVFAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpE ZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9j ZThkNWZlMGUyODAyMTU4YjY1Njk5YWVhZTE1NTFkNDg5OTQ4MTY3CgpNb2RpZmllZCBGaWxlcwot LS0tLS0tLS0tLS0tLQouLi4vcGdfc3RhdF9zdGF0ZW1lbnRzL2V4cGVjdGVkL2xldmVsX3RyYWNr aW5nLm91dCB8ICAgOCArLQpjb250cmliL3BnX3N0YXRfc3RhdGVtZW50cy9leHBlY3RlZC9wbGFu Y2FjaGUub3V0ICB8ICAgNiArLQpzcmMvcGwvcGxwZ3NxbC9zcmMvZXhwZWN0ZWQvcGxwZ3NxbF9z aW1wbGUub3V0ICAgICB8ICAxOSArKysrCnNyYy9wbC9wbHBnc3FsL3NyYy9wbF9leGVjLmMgICAg ICAgICAgICAgICAgICAgICAgIHwgMTAwICsrKysrKysrKysrKysrKysrKysrKwpzcmMvcGwvcGxw Z3NxbC9zcmMvc3FsL3BscGdzcWxfc2ltcGxlLnNxbCAgICAgICAgICB8ICAxNyArKysrCjUgZmls ZXMgY2hhbmdlZCwgMTQxIGluc2VydGlvbnMoKyksIDkgZGVsZXRpb25zKC0pCgo= --===============3420134121690507240==--