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 1qvafq-0066tl-W4 for pgsql-committers@arkaria.postgresql.org; Wed, 25 Oct 2023 09:59:38 +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 1qvafp-001fl2-Ep for pgsql-committers@arkaria.postgresql.org; Wed, 25 Oct 2023 09:59:37 +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 1qvafp-001fku-7k for pgsql-committers@lists.postgresql.org; Wed, 25 Oct 2023 09:59:37 +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.94.2) (envelope-from ) id 1qvafm-002DkQ-C2 for pgsql-committers@lists.postgresql.org; Wed, 25 Oct 2023 09:59:36 +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=jcLVWZLP4fB/F2ssJqQDUugzqUlULxryh4QW29pSdys=; b=55ht/+0d9HLXisJSReVX6tycT0 rI+g7WCtepUBgabAOGIUSkfh1tv0yaxHSxJpqZM28LnBPissJK9QW77W4WM9s9FUzlWKqqkTMudsY 35AdFE0V1IWUCjzEHhRabOdxsqwLzAOpDKsg2k2LMNtoa66xC388zhyUkEf3zUUgCU/b7VLP7db+M Hi1NF7rmNb77p9oc7l1gAroNqv2nsXZv3G81vuMvaFAJNbfKs1oMzrroENLABPBUJ9y07GnlrXF/b lBaQWbuev0vacbNAAlmocpWY8aE9NzGAjjNI3BSVn4uNKgV5Kfeldbjba+sbiFqYrTftJTXhNL3Ks Bx6OYqrw==; 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 1qvafm-00029u-3s for pgsql-committers@lists.postgresql.org; Wed, 25 Oct 2023 09:59:34 +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 1qvafl-002FJE-8E for pgsql-committers@lists.postgresql.org; Wed, 25 Oct 2023 09:59:33 +0000 Content-Type: multipart/mixed; boundary="===============0834511315720400577==" MIME-Version: 1.0 From: Alexander Korotkov To: pgsql-committers@lists.postgresql.org Subject: pgsql: Remove useless self-joins X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 25 Oct 2023 09:59:33 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0834511315720400577== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVtb3ZlIHVzZWxlc3Mgc2VsZi1qb2lucwoKVGhlIFNlbGYgSm9pbiBFbGltaW5hdGlvbiAoU0pF KSBmZWF0dXJlIHJlbW92ZXMgYW4gaW5uZXIgam9pbiBvZiBhIHBsYWluIHRhYmxlCnRvIGl0c2Vs ZiBpbiB0aGUgcXVlcnkgdHJlZSBpZiBpcyBwcm92ZWQgdGhhdCB0aGUgam9pbiBjYW4gYmUgcmVw bGFjZWQgd2l0aAphIHNjYW4gd2l0aG91dCBpbXBhY3RpbmcgdGhlIHF1ZXJ5IHJlc3VsdC4gIFNl bGYgam9pbiBhbmQgaW5uZXIgcmVsYXRpb24gYXJlCnJlcGxhY2VkIHdpdGggdGhlIG91dGVyIGlu IHF1ZXJ5LCBlcXVpdmFsZW5jZSBjbGFzc2VzLCBhbmQgcGxhbm5lciBpbmZvCnN0cnVjdHVyZXMu IEFsc28sIGlubmVyIHJlc3RyaWN0bGlzdCBtb3ZlcyB0byB0aGUgb3V0ZXIgb25lIHdpdGggcmVt b3ZpbmcKZHVwbGljYXRlZCBjbGF1c2VzLiBUaHVzLCB0aGlzIG9wdGltaXphdGlvbiByZWR1Y2Vz IHRoZSBsZW5ndGggb2YgdGhlIHJhbmdlCnRhYmxlIGxpc3QgKHRoaXMgZXNwZWNpYWxseSBtYWtl cyBzZW5zZSBmb3IgcGFydGl0aW9uZWQgcmVsYXRpb25zKSwgcmVkdWNlcwp0aGUgbnVtYmVyIG9m IHJlc3RyaWN0aW9uIGNsYXVzZXMgPT09IHNlbGVjdGl2aXR5IGVzdGltYXRpb25zLCBhbmQgcG90 ZW50aWFsbHkKY2FuIGltcHJvdmUgdG90YWwgcGxhbm5lciBwcmVkaWN0aW9uIGZvciB0aGUgcXVl cnkuCgpUaGUgU0pFIHByb29mIGlzIGJhc2VkIG9uIGlubmVycmVsX2lzX3VuaXF1ZSBtYWNoaW5l cnkuCgpXZSBjYW4gcmVtb3ZlIGEgc2VsZi1qb2luIHdoZW4gZm9yIGVhY2ggb3V0ZXIgcm93Ogog MS4gQXQgbW9zdCBvbmUgaW5uZXIgcm93IG1hdGNoZXMgdGhlIGpvaW4gY2xhdXNlLgogMi4gRWFj aCBtYXRjaGVkIGlubmVyIHJvdyBtdXN0IGJlIChwaHlzaWNhbGx5KSB0aGUgc2FtZSByb3cgYXMg dGhlIG91dGVyIG9uZS4KCkluIHRoaXMgcGF0Y2ggd2UgdXNlIHRoZSBuZXh0IGFwcHJvYWNoIHRv IGlkZW50aWZ5IGEgc2VsZi1qb2luOgogMS4gQ29sbGVjdCBhbGwgbWVyZ2Utam9pbmFibGUgam9p biBxdWFscyB3aGljaCBsb29rIGxpa2UgYS54ID0gYi54CiAyLiBBZGQgdG8gdGhlIGxpc3QgYWJv dmUgdGhlIGJhc2VyZXRyaWN0aW5mbyBvZiB0aGUgaW5uZXIgdGFibGUuCiAzLiBDaGVjayBpbm5l cnJlbF9pc191bmlxdWUoKSBmb3IgdGhlIHF1YWwgbGlzdC4gIElmIGl0IHJldHVybnMgZmFsc2Us IHNraXAKICAgIHRoaXMgcGFpciBvZiBqb2luaW5nIHRhYmxlcy4KIDQuIENoZWNrIHVuaXF1ZW5l c3MsIHByb3ZlZCBieSB0aGUgYmFzZXJlc3RyaWN0aW5mbyBjbGF1c2VzLiBUbyBwcm92ZQogICAg dGhlIHBvc3NpYmlsaXR5IG9mIHNlbGYtam9pbiBlbGltaW5hdGlvbiBpbm5lciBhbmQgb3V0ZXIg Y2xhdXNlcyBtdXN0IGhhdmUKICAgIGFuIGV4YWN0IG1hdGNoLgoKVGhlIHJlbGF0aW9uIHJlcGxh Y2VtZW50IHByb2NlZHVyZSBpcyBub3QgdHJpdmlhbCBhbmQgaXQgaXMgcGFydGx5IGNvbWJpbmVk CndpdGggdGhlIG9uZSwgdXNlZCB0byByZW1vdmUgdXNlbGVzcyBsZWZ0IGpvaW5zLiAgVGVzdHMs IGNvdmVyaW5nIHRoaXMgZmVhdHVyZSwKd2VyZSBhZGRlZCB0byBqb2luLnNxbC4gIFNvbWUgcmVn cmVzc2lvbiB0ZXN0cyBjaGFuZ2VkIGR1ZSB0byBzZWxmLWpvaW4gcmVtb3ZhbApsb2dpYy4KCkRp c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vZmxhdC82NDQ4NmIwYi0wNDA0LWUzOWUtMzIy ZC0wODAxMTU0OTAxZjMlNDBwb3N0Z3Jlc3Byby5ydQpBdXRob3I6IEFuZHJleSBMZXBpa2hvdiwg QWxleGFuZGVyIEt1em1lbmtvdgpSZXZpZXdlZC1ieTogVG9tIExhbmUsIFJvYmVydCBIYWFzLCBB bmRyZXMgRnJldW5kLCBTaW1vbiBSaWdncywgSm9uYXRoYW4gUy4gS2F0egpSZXZpZXdlZC1ieTog RGF2aWQgUm93bGV5LCBUaG9tYXMgTXVucm8sIEtvbnN0YW50aW4gS25pemhuaWssIEhlaWtraSBM aW5uYWthbmdhcwpSZXZpZXdlZC1ieTogSHl3ZWwgQ2FydmVyLCBMYXVyZW56IEFsYmUsIFJvbmFu IER1bmtsYXUsIHZpZ25lc2ggQywgWmhpaG9uZyBZdQpSZXZpZXdlZC1ieTogR3JlZyBTdGFyaywg SmFpbWUgQ2FzYW5vdmEsIE1pY2hhxYIgS8WCZWN6ZWssIEFsZW5hIFJ5YmFraW5hClJldmlld2Vk LWJ5OiBBbGV4YW5kZXIgS29yb3Rrb3YKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9kM2Q1NWNlNTcx MzY5ZGFkNmUxZDU4MmYxNjU1ZTVhM2ZiZDg1OTRhCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpkb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwgICAgICAgICAgICAgICAgICAgICAgfCAgIDE2 ICsKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvaW5keHBhdGguYyAgICAgICAgIHwgICAzOSAr CnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2FuYWx5emVqb2lucy5jICAgICB8IDEyMTEgKysr KysrKysrKysrKysrKysrKysrKystLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9wbGFubWFp bi5jICAgICAgICAgfCAgICA1ICsKc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWNfdGFibGVzLmMg ICAgICAgICAgIHwgICAxMCArCnNyYy9pbmNsdWRlL29wdGltaXplci9wYXRocy5oICAgICAgICAg ICAgICAgICB8ICAgIDMgKwpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcGxhbm1haW4uaCAgICAgICAg ICAgICAgfCAgICA2ICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9lcXVpdmNsYXNzLm91dCAg ICAgIHwgICAzMiArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvam9pbi5vdXQgICAgICAgICAg ICB8ICA4MDUgKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N5c3Zp ZXdzLm91dCAgICAgICAgfCAgICAzICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdXBkYXRh YmxlX3ZpZXdzLm91dCB8ICAgMTcgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvZXF1aXZjbGFzcy5z cWwgICAgICAgICAgIHwgICAxNiArCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2pvaW4uc3FsICAgICAg ICAgICAgICAgICB8ICAzNTkgKysrKysrKysKc3JjL3Rvb2xzL3BnaW5kZW50L3R5cGVkZWZzLmxp c3QgICAgICAgICAgICAgIHwgICAgMyArCjE0IGZpbGVzIGNoYW5nZWQsIDI0NTcgaW5zZXJ0aW9u cygrKSwgNjggZGVsZXRpb25zKC0pCgo= --===============0834511315720400577==--