Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcvrE-0001k6-Cf for pgsql-committers@arkaria.postgresql.org; Thu, 16 Mar 2023 22:14:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcvrC-0005Bf-Pw for pgsql-committers@arkaria.postgresql.org; Thu, 16 Mar 2023 22:13:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcvrC-0005BP-EW for pgsql-committers@lists.postgresql.org; Thu, 16 Mar 2023 22:13:58 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcvr5-0006R9-K5 for pgsql-committers@lists.postgresql.org; Thu, 16 Mar 2023 22:13:57 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcvr4-0008Sg-Ng for pgsql-committers@lists.postgresql.org; Thu, 16 Mar 2023 22:13:50 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pcvr3-003sne-Rb for pgsql-committers@lists.postgresql.org; Thu, 16 Mar 2023 22:13:50 +0000 Content-Type: multipart/mixed; boundary="===============4836865892013726122==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Enable use of Memoize atop an Append that came from UNION ALL. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 16 Mar 2023 22:13:50 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4836865892013726122== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5hYmxlIHVzZSBvZiBNZW1vaXplIGF0b3AgYW4gQXBwZW5kIHRoYXQgY2FtZSBmcm9tIFVOSU9O IEFMTC4KCmNyZWF0ZV9hcHBlbmRfcGF0aCgpIHdvdWxkIG9ubHkgYXBwbHkgZ2V0X2Jhc2VyZWxf cGFyYW1wYXRoaW5mbwp3aGVuIHRoZSBwYXRoIGlzIGZvciBhIHBhcnRpdGlvbmVkIHRhYmxlLCBi dXQgaXQncyBhbHNvIHBvdGVudGlhbGx5CnVzZWZ1bCBmb3IgcGF0aHMgZm9yIFVOSU9OIEFMTCBh cHBlbmRyZWxzLiAgU3BlY2lmaWNhbGx5LCB0aGF0CnN1cHBvcnRzIGJ1aWxkaW5nIGEgTWVtb2l6 ZSBwYXRoIGF0b3AgdGhpcyBvbmUuCgpXaGlsZSB3ZSdyZSBpbiB0aGUgdmljaW5pdHksIGRlbGV0 ZSBzb21lIGRlYWQgY29kZSBpbgpjcmVhdGVfbWVyZ2VfYXBwZW5kX3BsYW4oKTogdGhlcmUncyBu byBuZWVkIGZvciBpdCB0byBzdXBwb3J0CnBhcmFtZXRlcml6ZWQgTWVyZ2VBcHBlbmQgcGF0aHMs IGFuZCBpdCBkb2Vzbid0IGxvb2sgbGlrZSB0aGF0CmlzIGdvaW5nIHRvIGNoYW5nZSBhbnl0aW1l IHNvb24uICBJdCdsbCBiZSBlYXN5IGVub3VnaCB0byB1bmRvCnRoaXMgd2hlbi9pZiBpdCBiZWNv bWVzIHVzZWZ1bC4KClJpY2hhcmQgR3VvCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t L0NBTWJXczRfQUJTdTRQV0cyckUxcTEwdEp1Z0VYSFdncnUzVThkQWdrb0Z2Z3JiNmFFQUBtYWls LmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzliZmQyODIyYjMyMDFmNmIwZGUxZTg3 MzA1YjExZWUzODg1YjM2ZDkKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNr ZW5kL29wdGltaXplci9wbGFuL2NyZWF0ZXBsYW4uYyB8IDEyICsrLS0tLS0tLS0tLQpzcmMvYmFj a2VuZC9vcHRpbWl6ZXIvdXRpbC9wYXRobm9kZS5jICAgfCAxOCArKysrKysrKysrLS0tLS0tLS0K c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9tZW1vaXplLm91dCAgIHwgMjQgKysrKysrKysrKysr KysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL21lbW9pemUuc3FsICAgICAgICB8ICA4 ICsrKysrKysrCjQgZmlsZXMgY2hhbmdlZCwgNDQgaW5zZXJ0aW9ucygrKSwgMTggZGVsZXRpb25z KC0pCgo= --===============4836865892013726122==--