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 1u0gv2-005zlP-Aa for pgsql-committers@arkaria.postgresql.org; Fri, 04 Apr 2025 13:17:12 +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 1u0gv1-0006AS-2p for pgsql-committers@arkaria.postgresql.org; Fri, 04 Apr 2025 13:17:11 +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 1u0guu-0005Mw-RC for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 13:17:04 +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.96) (envelope-from ) id 1u0gur-002v95-2a for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 13:17:03 +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=j63/TOYgdCZVmQIwI9/ru93YyasGV63FFwTkkFJaIlg=; b=aQKF9LQBnNDp3mKcvsdGpkezGb IpmRN5Hx8Vf+dr7NTmC0KbgVsu+0tY5722beCpM3Z0tasNGfjRUT+eaNxGc6743ldo2wIWnzS6PzG oLkLbk96AiseChOOYYzeC4gK8K5u5kL7oogCBc7OqBj1pAvTE8coB5OKvR0TBkMZalcMkqmPLnkBj lJabQ5czmq9e/cbGLTYYVtaEy/JxHCd5LOgLznrOMOgwYWe1kqDFQz8JhXJ/CPQ7PK/TXPK2QxDEo rNT0LsPpKFzE2e0ejoiIlBv6ef/gFLFAZGphx8rK2CMgOVZ069mB3bUXPiKH9lyfaxmelt74v71F4 uy6yWZ+w==; 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 1u0gur-0003Y8-04 for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 13:17:01 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u0guq-002dS9-1m for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 13:17:00 +0000 Content-Type: multipart/mixed; boundary="===============1450545782692716159==" MIME-Version: 1.0 From: Alexander Korotkov To: pgsql-committers@lists.postgresql.org Subject: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 04 Apr 2025 13:17:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1450545782692716159== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q29udmVydCAneCBJTiAoVkFMVUVTIC4uLiknIHRvICd4ID0gQU5ZIC4uLicgdGhlbiBhcHByb3By aWF0ZQoKVGhpcyBjb21taXQgaW1wbGVtZW50cyB0aGUgYXV0b21hdGljIGNvbnZlcnNpb24gb2Yg J3ggSU4gKFZBTFVFUyAuLi4pJyBpbnRvClNjYWxhckFycmF5T3BFeHByLiAgVGhhdCBzaW1wbGlm aWVzIHRoZSBxdWVyeSB0cmVlLCBlbGltaW5hdGluZyB0aGUgYXBwZWFyYW5jZQpvZiBhbiB1bm5l Y2Vzc2FyeSBqb2luLgoKU2luY2UgVkFMVUVTIGRlc2NyaWJlcyBhIHJlbGF0aW9uYWwgdGFibGUs IGFuZCB0aGUgdmFsdWUgb2Ygc3VjaCBhIGxpc3QgaXMKYSB0YWJsZSByb3csIHRoZSBvcHRpbWl6 ZXIgd2lsbCBsaWtlbHkgZmFjZSBhbiB1bmRlcmVzdGltYXRpb24gcHJvYmxlbSBkdWUgdG8KdGhl IGluYWJpbGl0eSB0byBlc3RpbWF0ZSBjYXJkaW5hbGl0eSB0aHJvdWdoIE1DViBzdGF0aXN0aWNz LiAgVGhlIGNhcmRpbmFsaXR5CmV2YWx1YXRpb24gbWVjaGFuaXNtIGNhbiB3b3JrIHdpdGggdGhl IGFycmF5IGluY2x1c2lvbiBjaGVjayBvcGVyYXRpb24uCklmIHRoZSBhcnJheSBpcyBzbWFsbCBl bm91Z2ggKDwgMTAwIGVsZW1lbnRzKSwgaXQgd2lsbCBwZXJmb3JtIGEgc3RhdGlzdGljYWwKZXZh bHVhdGlvbiBlbGVtZW50IGJ5IGVsZW1lbnQuCgpXZSBwZXJmb3JtIHRoZSB0cmFuc2Zvcm1hdGlv biBpbiB0aGUgY29udmVydF9BTllfc3VibGlua190b19qb2luKCkgaWYgVkFMVUVTClJURSBpcyBw cm9wZXIgYW5kIHRoZSB0cmFuc2Zvcm1hdGlvbiBpcyBjb252ZXJ0aWJsZS4gIFRoZSBjb252ZXJz aW9uIGlzIG9ubHkKcG9zc2libGUgZm9yIG9wZXJhdGlvbnMgb24gc2NhbGFyIHZhbHVlcywgbm90 IHJvd3MuICBBbHNvLCB3ZSBjdXJyZW50bHkKc3VwcG9ydCB0aGUgdHJhbnNmb3JtYXRpb24gb25s eSB3aGVuIGl0IGVuZHMgdXAgd2l0aCBhIGNvbnN0YW50IGFycmF5LgpPdGhlcndpc2UsIHRoZSBl dmFsdWF0aW9uIG9mIG5vbi1oYXNoZWQgU0FPUCBtaWdodCBiZSBzbG93ZXIgdGhhbiB0aGUKY29y cmVzcG9uZGluZyBIYXNoIEpvaW4gd2l0aCBWQUxVRVMuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bv c3Rnci5lcy9tLzAxODQyMTJkLTEyNDgtNGYxZi1hNDJkLWY1Y2IxYzE5NzZkMiU0MHRhbnRvcmxh YnMuY29tCkF1dGhvcjogQWxlbmEgUnliYWtpbmEgPGEucnliYWtpbmFAcG9zdGdyZXNwcm8ucnU+ CkF1dGhvcjogQW5kcmVpIExlcGlraG92IDxsZXBpaG92QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6 IEl2YW4gS3VzaCA8aXZhbi5rdXNoQHRhbnRvcmxhYnMuY29tPgpSZXZpZXdlZC1ieTogQWxleGFu ZGVyIEtvcm90a292IDxhZWtvcm90a292QGdtYWlsLmNvbT4KCkJyYW5jaAotLS0tLS0KbWFzdGVy CgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlm Zi9jMDk2MmExMTNkMWYyZjk0Y2I3MjIyYTdjYTAyNWE2N2U5Y2UzODYwCgpNb2RpZmllZCBGaWxl cwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9zdWJzZWxlY3QuYyAg ICB8ICA4MCArKysrKysrKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwam9pbnRyZWUu YyB8ICAxMiArKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9jbGF1c2VzLmMgICAgICB8ICAx NCArLQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvc3Vic2VsZWN0LmggICAgICAgICB8ICAgMyArCnNy Yy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3Vic2VsZWN0Lm91dCAgIHwgMzA4ICsrKysrKysrKysr KysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9zdWJzZWxlY3Quc3FsICAg ICAgICB8IDEwMCArKysrKysrKysrCjYgZmlsZXMgY2hhbmdlZCwgNTEyIGluc2VydGlvbnMoKyks IDUgZGVsZXRpb25zKC0pCgo= --===============1450545782692716159==--