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 1pMZax-0001XY-F2 for pgsql-committers@arkaria.postgresql.org; Mon, 30 Jan 2023 19:13:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pMZav-0000hd-Jn for pgsql-committers@arkaria.postgresql.org; Mon, 30 Jan 2023 19:13:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pMZav-0000c9-CK for pgsql-committers@lists.postgresql.org; Mon, 30 Jan 2023 19:13:33 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pMZas-00048t-IU for pgsql-committers@lists.postgresql.org; Mon, 30 Jan 2023 19:13:32 +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 1pMZaq-0001kQ-RH for pgsql-committers@lists.postgresql.org; Mon, 30 Jan 2023 19:13:28 +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 1pMZao-000l40-Q3 for pgsql-committers@lists.postgresql.org; Mon, 30 Jan 2023 19:13:28 +0000 Content-Type: multipart/mixed; boundary="===============1663711355693004918==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Invent "join domains" to replace the below_outer_join hack. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 30 Jan 2023 19:13:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1663711355693004918== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW52ZW50ICJqb2luIGRvbWFpbnMiIHRvIHJlcGxhY2UgdGhlIGJlbG93X291dGVyX2pvaW4gaGFj ay4KCkVxdWl2YWxlbmNlQ2xhc3NlcyBhcmUgbm93IHVuZGVyc3Rvb2QgYXMgYXBwbHlpbmcgd2l0 aGluIGEgImpvaW4KZG9tYWluIiwgd2hpY2ggaXMgYSBzZXQgb2YgaW5uZXItam9pbmVkIHJlbGF0 aW9ucyAocG9zc2libHkgdW5kZXJuZWF0aAphbiBvdXRlciBqb2luKS4gIFdlIG5vIGxvbmdlciBu ZWVkIHRvIHRyZWF0IGFuIEVDIGZyb20gYmVsb3cgYW4gb3V0ZXIKam9pbiBhcyBhIHNlY29uZC1j bGFzcyBjaXRpemVuLgoKSSBoYXZlIGhvcGVzIG9mIGV2ZW50dWFsbHkgYmVpbmcgYWJsZSB0byB0 cmVhdCBvdXRlci1qb2luIGNsYXVzZXMgdmlhCkVxdWl2YWxlbmNlQ2xhc3NlcywgYnkgbWVhbnMg b2Ygb25seSBhcHBseWluZyBkZWR1Y3Rpb25zIHdpdGhpbiB0aGUKRUMncyBqb2luIGRvbWFpbi4g IFRoZXJlIGFyZSBzdGlsbCBwcm9ibGVtcyBpbiB0aGUgd2F5IG9mIHRoYXQsIHRob3VnaCwKc28g Zm9yIG5vdyB0aGUgcmVjb25zaWRlcl9vdXRlcl9qb2luX2NsYXVzZSBsb2dpYyBpcyBzdGlsbCBo ZXJlLgoKSSBoYXZlbid0IGJlZW4gYWJsZSB0byBnZXQgcmlkIG9mIFJlc3RyaWN0SW5mby5pc19w dXNoZWRfZG93biBlaXRoZXIsCmJ1dCBJIHdvbmRlciBpZiB0aGF0IGNvdWxkIGJlIHJlY2FzdCB1 c2luZyBKb2luRG9tYWlucy4KCkkgaGFkIHRvIGhhY2sgb25lIHRlc3QgY2FzZSBpbiBwb3N0Z3Jl c19mZHcuc3FsIHRvIG1ha2UgaXQgc3RpbGwgdGVzdAp3aGF0IGl0IHdhcyBtZWFudCB0bywgYmVj YXVzZSBwb3N0Z3Jlc19mZHcgaXMgaW5jb25zaXN0ZW50IGFib3V0CmhvdyBpdCBkZWFscyB3aXRo IHF1YWxzIGNvbnRhaW5pbmcgbm9uLXNoaXBwYWJsZSBleHByZXNzaW9uczsgc2VlCmh0dHBzOi8v cG9zdGdyLmVzL20vMTY5MTM3NC4xNjcxNjU5ODM4QHNzcy5wZ2gucGEudXMuICBUaGF0IHNob3Vs ZApiZSBpbXByb3ZlZCwgYnV0IEkgZG9uJ3QgdGhpbmsgaXQncyB3aXRoaW4gdGhlIHNjb3BlIG9m IHRoaXMgcGF0Y2gKc2VyaWVzLgoKUGF0Y2ggYnkgbWU7IHRoYW5rcyB0byBSaWNoYXJkIEd1byBm b3IgcmV2aWV3LgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS84MzAyNjkuMTY1NjY5 Mzc0N0Bzc3MucGdoLnBhLnVzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0t Cmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvM2JlZjU2ZTExNjUwYTMz ZjcwYWRlYjZkZDQ0MmJjMmI0OGJiOWI3MgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0K Y29udHJpYi9wb3N0Z3Jlc19mZHcvZXhwZWN0ZWQvcG9zdGdyZXNfZmR3Lm91dCB8ICAxNCArLQpj b250cmliL3Bvc3RncmVzX2Zkdy9zcWwvcG9zdGdyZXNfZmR3LnNxbCAgICAgIHwgICAyICstCnNy Yy9iYWNrZW5kL25vZGVzL291dGZ1bmNzLmMgICAgICAgICAgICAgICAgICAgfCAgIDEgLQpzcmMv YmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9lcXVpdmNsYXNzLmMgICAgICAgIHwgMTMzICsrKysrKysr Ky0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9qb2lucGF0aC5jICAgICAgICAgIHwg IDEyIC0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2NyZWF0ZXBsYW4uYyAgICAgICAgfCAg IDUgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vaW5pdHNwbGFuLmMgICAgICAgICB8IDIx MyArKysrKysrKysrKysrLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3Bs YW5uZXIuYyAgICAgICAgICAgfCAgMTAgKysKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJl cGpvaW50cmVlLmMgICAgICB8ICAgMiArCnNyYy9pbmNsdWRlL25vZGVzL3BhdGhub2Rlcy5oICAg ICAgICAgICAgICAgICAgfCAgNjcgKysrKysrLS0Kc3JjL2luY2x1ZGUvb3B0aW1pemVyL3BhdGhz LmggICAgICAgICAgICAgICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcGxhbm1h aW4uaCAgICAgICAgICAgICAgIHwgICAxIC0KMTIgZmlsZXMgY2hhbmdlZCwgMjY5IGluc2VydGlv bnMoKyksIDE5MyBkZWxldGlvbnMoLSkKCg== --===============1663711355693004918==--