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 1rtazl-00Fz66-59 for pgsql-committers@arkaria.postgresql.org; Sun, 07 Apr 2024 22:28:13 +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 1rtazk-00D6pT-5v for pgsql-committers@arkaria.postgresql.org; Sun, 07 Apr 2024 22:28:12 +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 1rtazj-00D6pL-Ub for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 22:28:11 +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.94.2) (envelope-from ) id 1rtazg-001SS6-Kn for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 22:28:11 +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=mlvqXO4OXD7o37I5pL8PD5+8qIaCOlOg5G8H+c33kHw=; b=7V/MHgESKNcb2//ReeY2jaC+gi v0QplwY/Dztv+Ab4hIF3XY3NsGYzr6x/zGsTBFzWQEdtdkIk4QZjRMORIu0BxpRnLjsW5mnUIR/tB aS/rvEzJCo287MHoapCmsXl4tqelSExzC2FqGoSfYwvYza53FxiXHJWvLBrlZwiBUD12m7BfE2lbN LErQfAzpXHy/uXCbN+HmUYJROPqmIqXRnMaakjpfFDRFwWLOHTZK3nqGh0s5wiIF33OksWPTMHutb GEPrBKJ4oZRxZvWPFGOP4HjmV59GEESM3vgT/soLre5iwPAsWZ0qY28v5L3TnTfgoyc1qqKQH9rIQ 9/N871IQ==; 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 1rtazf-0038N5-2f for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 22:28:07 +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 1rtaze-0011lv-55 for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 22:28:06 +0000 Content-Type: multipart/mixed; boundary="===============0789485101840804817==" MIME-Version: 1.0 From: Alexander Korotkov To: pgsql-committers@lists.postgresql.org Subject: pgsql: Transform OR clauses to ANY expression X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 07 Apr 2024 22:28:06 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0789485101840804817== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VHJhbnNmb3JtIE9SIGNsYXVzZXMgdG8gQU5ZIGV4cHJlc3Npb24KClJlcGxhY2UgKGV4cHIgb3Ag QzEpIE9SIChleHByIG9wIEMyKSAuLi4gd2l0aCBleHByIG9wIEFOWShBUlJBWVtDMSwgQzIsIC4u Ll0pCm9uIHRoZSBwcmVsaW1pbmFyeSBzdGFnZSBvZiBvcHRpbWl6YXRpb24gd2hlbiB3ZSBhcmUg c3RpbGwgd29ya2luZyB3aXRoIHRoZQpleHByZXNzaW9uIHRyZWUuCgpIZXJlIENuIGlzIGEgbi10 aCBjb25zdGFudCBleHByZXNzaW9uLCAnZXhwcicgaXMgbm9uLWNvbnN0YW50IGV4cHJlc3Npb24s ICdvcCcKaXMgYW4gb3BlcmF0b3Igd2hpY2ggcmV0dXJucyBib29sZWFuIHJlc3VsdCBhbmQgaGFz IGEgY29tbXV0ZXIgKGZvciB0aGUgY2FzZQpvZiByZXZlcnNlIG9yZGVyIG9mIGNvbnN0YW50IGFu ZCBub24tY29uc3RhbnQgcGFydHMgb2YgdGhlIGV4cHJlc3Npb24sCmxpa2UgJ0NuIG9wIGV4cHIn KS4KClNvbWV0aW1lcyBpdCBjYW4gbGVhZCB0byBub3Qgb3B0aW1hbCBwbGFuLiAgVGhpcyBpcyB3 aHkgdGhlcmUgaXMgYQpvcl90b19hbnlfdHJhbnNmb3JtX2xpbWl0IEdVQy4gIEl0IHNwZWNpZmll cyBhIHRocmVzaG9sZCB2YWx1ZSBvZiBsZW5ndGggb2YKYXJndW1lbnRzIGluIGFuIE9SIGV4cHJl c3Npb24gdGhhdCB0cmlnZ2VycyB0aGUgT1ItdG8tQU5ZIHRyYW5zZm9ybWF0aW9uLgpHZW5lcmFs bHksIG1vcmUgZ3JvdXBhYmxlIE9SIGFyZ3VtZW50cyBtZWFuIHRoYXQgdHJhbnNmb3JtYXRpb24g d2lsbCBiZSBtb3JlCmxpa2VseSB0byB3aW4gdGhhbiB0byBsb3NlLgoKRGlzY3Vzc2lvbjogaHR0 cHM6Ly9wb3N0Z3IuZXMvbS81NjdFRDZDQS4yMDQwNTA0JTQwc2lnYWV2LnJ1CkF1dGhvcjogQWxl bmEgUnliYWtpbmEgPGxlbmEucmliYWNraW5hQHlhbmRleC5ydT4KQXV0aG9yOiBBbmRyZXkgTGVw aWtob3YgPGEubGVwaWtob3ZAcG9zdGdyZXNwcm8ucnU+ClJldmlld2VkLWJ5OiBQZXRlciBHZW9n aGVnYW4gPHBnQGJvd3QuaWU+ClJldmlld2VkLWJ5OiBSYW5pZXIgVmlsZWxhIDxyYW5pZXIudmZA Z21haWwuY29tPgpSZXZpZXdlZC1ieTogQWxleGFuZGVyIEtvcm90a292IDxhZWtvcm90a292QGdt YWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFJvYmVydCBIYWFzIDxyb2JlcnRtaGFhc0BnbWFpbC5jb20+ ClJldmlld2VkLWJ5OiBKaWFuIEhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+CgpCcmFu Y2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwu b3JnL3BnL2NvbW1pdGRpZmYvNzJiZDM4Y2M5OWExNWRhNmY5NzM3M2ZhZTk4MDI3YzkwOGMzOThl YQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21s ICAgICAgICAgICAgICAgICAgICAgIHwgIDU3ICsrKysKc3JjL2JhY2tlbmQvbm9kZXMvcXVlcnlq dW1ibGVmdW5jcy5jICAgICAgICAgIHwgIDI3ICsrCnNyYy9iYWNrZW5kL29wdGltaXplci9wcmVw L3ByZXBxdWFsLmMgICAgICAgICB8IDM5OSArKysrKysrKysrKysrKysrKysrKysrKysrLQpzcmMv YmFja2VuZC91dGlscy9taXNjL2d1Y190YWJsZXMuYyAgICAgICAgICAgfCAgMTIgKwpzcmMvYmFj a2VuZC91dGlscy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUgfCAgIDEgKwpzcmMvaW5jbHVk ZS9ub2Rlcy9xdWVyeWp1bWJsZS5oICAgICAgICAgICAgICAgfCAgIDEgKwpzcmMvaW5jbHVkZS9v cHRpbWl6ZXIvb3B0aW1pemVyLmggICAgICAgICAgICAgfCAgIDIgKwpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL2NyZWF0ZV9pbmRleC5vdXQgICAgfCAxNTkgKysrKysrKysrKwpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL2pvaW4ub3V0ICAgICAgICAgICAgfCAgNTAgKysrKwpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL3BhcnRpdGlvbl9wcnVuZS5vdXQgfCAgMzcgKy0tCnNyYy90ZXN0L3Jl Z3Jlc3Mvc3FsL2NyZWF0ZV9pbmRleC5zcWwgICAgICAgICB8ICA0NSArKysKc3JjL3Rlc3QvcmVn cmVzcy9zcWwvam9pbi5zcWwgICAgICAgICAgICAgICAgIHwgIDExICsKc3JjL3Rlc3QvcmVncmVz cy9zcWwvcGFydGl0aW9uX3BydW5lLnNxbCAgICAgIHwgICAyICsKc3JjL3Rvb2xzL3BnaW5kZW50 L3R5cGVkZWZzLmxpc3QgICAgICAgICAgICAgIHwgICAyICsKMTQgZmlsZXMgY2hhbmdlZCwgNzg1 IGluc2VydGlvbnMoKyksIDIwIGRlbGV0aW9ucygtKQoK --===============0789485101840804817==--