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 1r8fHC-00B3Tl-96 for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Nov 2023 11:32:14 +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 1r8fHA-00GtIM-OP for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Nov 2023 11:32:12 +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 1r8ehI-00GbZY-2d for pgsql-bugs@lists.postgresql.org; Thu, 30 Nov 2023 10:55:08 +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 1r8ehF-0085g8-2m for pgsql-bugs@lists.postgresql.org; Thu, 30 Nov 2023 10:55:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=D0SxMN3L1SIJJYcNIy6LkcKUxULI652zWCFTGQc0Cwg=; b=e79nA6gZKRYKOZQyw1Tu7zKHRT wPRq4UIocSOXGXJM1aKJ+0z3QNJ0/YshWB9I2NO+DslU8bX38elAfbE82LHZhE6SyXQgIKUryPfgu jrhNig7Kx/k4zwBTBDSLlLS9jMfOMHKhL4D9+BhZ1G06EVRVDdqlgZZ/F6G8URratwHrmnHr7I4lk FQyJFdXGbYIlhf3FKR2kqSEAewrbTNWa+eiKO2gVYzEhI3wiIYf/KmjDwhBusFnxddiwFN3UnUwx0 mJxxklcLzqf1O9IwjOMk8PYpt6D3se3KMf/atOQqWgRw0QtILl2vOSJlGDSsfx9yY6eSkIvHMht7S i7wTl60Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8ehE-00B8Zr-AT for pgsql-bugs@lists.postgresql.org; Thu, 30 Nov 2023 10:55:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r8ehB-00DjyH-8Q for pgsql-bugs@lists.postgresql.org; Thu, 30 Nov 2023 10:55:02 +0000 Content-Type: multipart/mixed; boundary="===============0547800027845631472==" MIME-Version: 1.0 Subject: BUG #18218: NOT LIKE ANY returns same result as LIKE ANY when array items are wrapped into E'' To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: baurzhansahariev@gmail.com Reply-To: baurzhansahariev@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 30 Nov 2023 10:54:36 +0000 Message-ID: <18218-8cbdd922e41ea291@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0547800027845631472== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODIxOApMb2dnZWQgYnk6ICAgICAgICAgIEJhdXJ6aGFuIFNha2hhcml5 ZXYKRW1haWwgYWRkcmVzczogICAgICBiYXVyemhhbnNhaGFyaWV2QGdtYWlsLmNvbQpQb3N0Z3Jl U1FMIHZlcnNpb246IDE1LjAKT3BlcmF0aW5nIHN5c3RlbTogICBNYWNPUwpEZXNjcmlwdGlvbjog ICAgICAgIAoKaHR0cHM6Ly93d3cuZGItZmlkZGxlLmNvbS9mL2NwTmpXUkxtUVQ2VUZiMndFbzJM b0cvMA0KDQpzZWxlY3QgJ1RleHRUb01hdGNoJyBsaWtlIGFueSAoYXJyYXlbRSdUZVwldGNoJywg RSdub21hdGNoJ10pOyAtLSB0cnVlLApjb3JyZWN0DQpzZWxlY3QgJ1RleHRUb01hdGNoJyBOT1Qg bGlrZSBhbnkgKGFycmF5W0UnVGVcJXRjaCcsIEUnbm9tYXRjaCddKTsgLS0gdHJ1ZQpidXQgbXVz dCBiZSBmYWxzZSBiZWNhdXNlIGl0J3MgYSBuZWdhdGVkIHZlcnNpb24gb2YgdGhlIGV4cHJlc3Np b24gYWJvdmUNCg0KUGxlYXNlIG5vdGUsIHRoYXQgdmVyc2lvbnMgd2l0aG91dCBFJycgd29yayBh cyBleHBlY3RlZC4gDQpzZWxlY3QgJ1RleHRUb01hdGNoJyBsaWtlIGFueSAoYXJyYXlbJ1RlXCV0 Y2gnLCAnbm9tYXRjaCddKTsgLS0gZmFsc2UNCnNlbGVjdCAnVGV4dFRvTWF0Y2gnIE5PVCBsaWtl IGFueSAoYXJyYXlbJ1RlXCV0Y2gnLCAnbm9tYXRjaCddKTsgLS0gdHJ1ZQoK --===============0547800027845631472==--