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 1tmp8h-00BeOb-S4 for pgsql-committers@arkaria.postgresql.org; Tue, 25 Feb 2025 07:14:00 +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 1tmp8h-00FE5h-5f for pgsql-committers@arkaria.postgresql.org; Tue, 25 Feb 2025 07:13:59 +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 ) id 1tmp7P-00FD3s-Km for pgsql-committers@lists.postgresql.org; Tue, 25 Feb 2025 07:12:39 +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.96) (envelope-from ) id 1tmp7M-000gcx-2l for pgsql-committers@lists.postgresql.org; Tue, 25 Feb 2025 07:12:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=eR8HJQI0um3tk2i2+/15J60JP7CyQuGumbGePlBhYbQ=; b=H2EHF/Uds/JNaodIBvRE85gSW5 7dKoS+Y4KCwObMdDVznZ88KtD7FKzwO/8JiFGGsPDXBYVDc411MjRmA/2AMFuNsTv9l8PeZJ/oq39 4xB1AOHFpHEEy7WCRtAxiunkjk8kW04lDUU+CPR4rV+VOCLbAYE4xhJVOw7OmrjydS7oF+ZKMoUTA /euVwi6FBtG541g/ZWwgviu/A5b4pdTHHgOZyqMpplBtSEcXPb7bOYBhKQxGGLXW6rKjxkXvO3zpJ 2yylerP2cM97tebhryOwY1vSLQWd5pfVBBfQcgJ3i/LMZSHePN8UJq0SQSKYb+0Gg5RDAs3YS9OZt hJw6+Cxg==; 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 1tmp7L-001jxA-Nx for pgsql-committers@lists.postgresql.org; Tue, 25 Feb 2025 07:12:35 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tmp7K-000ZsN-2f for pgsql-committers@lists.postgresql.org; Tue, 25 Feb 2025 07:12:35 +0000 Content-Type: multipart/mixed; boundary="===============8424154489554237304==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Expand virtual generated columns in the planner X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 25 Feb 2025 07:12:35 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8424154489554237304== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RXhwYW5kIHZpcnR1YWwgZ2VuZXJhdGVkIGNvbHVtbnMgaW4gdGhlIHBsYW5uZXIKCkNvbW1pdCA4 M2VhNmM1NDAgYWRkZWQgc3VwcG9ydCBmb3IgdmlydHVhbCBnZW5lcmF0ZWQgY29sdW1ucyB0aGF0 IGFyZQpjb21wdXRlZCBvbiByZWFkLiAgQWxsIFZhciBub2RlcyBpbiB0aGUgcXVlcnkgdGhhdCBy ZWZlcmVuY2UgdmlydHVhbApnZW5lcmF0ZWQgY29sdW1ucyBtdXN0IGJlIHJlcGxhY2VkIHdpdGgg dGhlIGNvcnJlc3BvbmRpbmcgZ2VuZXJhdGlvbgpleHByZXNzaW9ucy4gIEN1cnJlbnRseSwgdGhp cyByZXBsYWNlbWVudCBvY2N1cnMgaW4gdGhlIHJld3JpdGVyLgpIb3dldmVyLCB0aGlzIGFwcHJv YWNoIGhhcyBzZXZlcmFsIGlzc3Vlcy4gIElmIGEgVmFyIHJlZmVyZW5jaW5nIGEKdmlydHVhbCBn ZW5lcmF0ZWQgY29sdW1uIGhhcyBhbnkgdmFybnVsbGluZ3JlbHMsIHRob3NlIHZhcm51bGxpbmdy ZWxzCm5lZWQgdG8gYmUgcHJvcGFnYXRlZCBpbnRvIHRoZSBnZW5lcmF0aW9uIGV4cHJlc3Npb24u ICBGYWlsaW5nIHRvIGRvCnNvIGNhbiBsZWFkIHRvICJ3cm9uZyB2YXJudWxsaW5ncmVscyIgZXJy b3JzIGFuZCBpbXByb3BlciBvdXRlci1qb2luCnJlbW92YWwuCgpBZGRpdGlvbmFsbHksIGlmIHN1 Y2ggYSBWYXIgY29tZXMgZnJvbSB0aGUgbnVsbGFibGUgc2lkZSBvZiBhbiBvdXRlcgpqb2luLCB3 ZSBtYXkgbmVlZCB0byB3cmFwIHRoZSBnZW5lcmF0aW9uIGV4cHJlc3Npb24gaW4gYQpQbGFjZUhv bGRlclZhciB0byBlbnN1cmUgdGhhdCBpdCBpcyBldmFsdWF0ZWQgYXQgdGhlIHJpZ2h0IHBsYWNl IGFuZApoZW5jZSBpcyBmb3JjZWQgdG8gbnVsbCB3aGVuIHRoZSBvdXRlciBqb2luIHNob3VsZCBk byBzby4gIEluIGNlcnRhaW4KY2FzZXMsIHN1Y2ggYXMgd2hlbiB0aGUgcXVlcnkgdXNlcyBncm91 cGluZyBzZXRzLCB3ZSBhbHNvIG5lZWQgYQpQbGFjZUhvbGRlclZhciBmb3IgYW55dGhpbmcgdGhh dCBpcyBub3QgYSBzaW1wbGUgVmFyIHRvIGlzb2xhdGUKc3ViZXhwcmVzc2lvbnMuICBGYWlsdXJl IHRvIGRvIHNvIGNhbiByZXN1bHQgaW4gaW5jb3JyZWN0IHJlc3VsdHMuCgpUbyBmaXggdGhlc2Ug aXNzdWVzLCB0aGlzIHBhdGNoIGV4cGFuZHMgdGhlIHZpcnR1YWwgZ2VuZXJhdGVkIGNvbHVtbnMK aW4gdGhlIHBsYW5uZXIgcmF0aGVyIHRoYW4gaW4gdGhlIHJld3JpdGVyLCBhbmQgbGV2ZXJhZ2Vz IHRoZQpwdWxsdXBfcmVwbGFjZV92YXJzIGFyY2hpdGVjdHVyZSB0byBhdm9pZCBjb2RlIGR1cGxp Y2F0aW9uLiAgVGhlCmdlbmVyYXRpb24gZXhwcmVzc2lvbnMgd2lsbCBiZSBjb3JyZWN0bHkgbWFy a2VkIHdpdGggbnVsbGluZ3JlbCBiaXRzCmFuZCB3cmFwcGVkIGluIFBsYWNlSG9sZGVyVmFycyB3 aGVuIG5lZWRlZCBieSB0aGUgcHVsbHVwX3JlcGxhY2VfdmFycwpjYWxsYmFjayBmdW5jdGlvbi4g IFRoaXMgcmVxdWlyZXMgaGFuZGxpbmcgdGhlIE9MRC9ORVcgUkVUVVJOSU5HIGxpc3QKVmFycyBp biBwdWxsdXBfcmVwbGFjZV92YXJzX2NhbGxiYWNrLCBhcyBpdCBtYXkgbm93IGRlYWwgd2l0aCBW YXJzCnJlZmVyZW5jaW5nIHRoZSByZXN1bHQgcmVsYXRpb24gaW5zdGVhZCBvZiBhIHN1YnF1ZXJ5 LgoKVGhlICJ3cm9uZyB2YXJudWxsaW5ncmVscyIgZXJyb3Igd2FzIHJlcG9ydGVkIGJ5IEFsZXhh bmRlciBMYWtoaW4uClRoZSBpbmNvcnJlY3QgcmVzdWx0IGlzc3VlIGFuZCB0aGUgaW1wcm9wZXIg b3V0ZXItam9pbiByZW1vdmFsIGlzc3VlCndlcmUgcmVwb3J0ZWQgYnkgUmljaGFyZCBHdW8uCgpB dXRob3I6IFJpY2hhcmQgR3VvIDxndW9mZW5nbGludXhAZ21haWwuY29tPgpBdXRob3I6IERlYW4g UmFzaGVlZCA8ZGVhbi5hLnJhc2hlZWRAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogSmlhbiBIZSA8 amlhbi51bml2ZXJzYWxpdHlAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tLzc1ZWIxYTZmLWQ1OWYtNDJlNi04YTc4LTEyNGVlODA4Y2RhN0BnbWFpbC5jb20KCkJyYW5j aAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5v cmcvcGcvY29tbWl0ZGlmZi8xZTQzNTFhZjMyOWYyOTQ5YzY3OWEyMTVmNjNjNTFkNjYzZWNkNzE1 CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxh bi9wbGFubmVyLmMgICAgICAgICAgICB8ICAgOCArCnNyYy9iYWNrZW5kL29wdGltaXplci9wcmVw L3ByZXBqb2ludHJlZS5jICAgICAgIHwgMTk2ICsrKysrKysrKysrKysrKysrKysrKysrKwpzcmMv YmFja2VuZC9yZXdyaXRlL3Jld3JpdGVIYW5kbGVyLmMgICAgICAgICAgICB8ICA5MSArKysrKy0t LS0tLQpzcmMvYmFja2VuZC9yZXdyaXRlL3Jld3JpdGVNYW5pcC5jICAgICAgICAgICAgICB8ICAg MiArLQpzcmMvaW5jbHVkZS9ub2Rlcy9wcmltbm9kZXMuaCAgICAgICAgICAgICAgICAgICB8ICAg MiArLQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcHJlcC5oICAgICAgICAgICAgICAgICAgICB8ICAg MSArCnNyYy9pbmNsdWRlL3Jld3JpdGUvcmV3cml0ZUhhbmRsZXIuaCAgICAgICAgICAgIHwgICAx ICsKc3JjL2luY2x1ZGUvcmV3cml0ZS9yZXdyaXRlTWFuaXAuaCAgICAgICAgICAgICAgfCAgIDMg KwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVyYXRlZF92aXJ0dWFsLm91dCB8IDEzMCAr KysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2dlbmVyYXRlZF92aXJ0dWFsLnNx bCAgICAgIHwgIDU3ICsrKysrKysKMTAgZmlsZXMgY2hhbmdlZCwgNDQ1IGluc2VydGlvbnMoKyks IDQ2IGRlbGV0aW9ucygtKQoK --===============8424154489554237304==--