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 1tGCOt-001TjI-P2 for pgsql-committers@arkaria.postgresql.org; Wed, 27 Nov 2024 07:23:51 +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 1tGCOs-00Clt5-C6 for pgsql-committers@arkaria.postgresql.org; Wed, 27 Nov 2024 07:23:50 +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 1tGCOs-00Clsw-4q for pgsql-committers@lists.postgresql.org; Wed, 27 Nov 2024 07:23:50 +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 1tGCOp-004HfJ-3L for pgsql-committers@lists.postgresql.org; Wed, 27 Nov 2024 07:23:49 +0000 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 1tGCOm-00Cd5S-RH for pgsql-committers@lists.postgresql.org; Wed, 27 Nov 2024 07:23:44 +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 1tGCOm-003irY-4m for pgsql-committers@lists.postgresql.org; Wed, 27 Nov 2024 07:23:44 +0000 Content-Type: multipart/mixed; boundary="===============3416072406886485035==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Support LIKE with nondeterministic collations X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 27 Nov 2024 07:23:44 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3416072406886485035== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3VwcG9ydCBMSUtFIHdpdGggbm9uZGV0ZXJtaW5pc3RpYyBjb2xsYXRpb25zCgpUaGlzIGFsbG93 cyBmb3IgZXhhbXBsZSB1c2luZyBMSUtFIHdpdGggY2FzZS1pbnNlbnNpdGl2ZSBjb2xsYXRpb25z LgpUaGVyZSB3YXMgcHJldmlvdXNseSBubyBpbnRlcm5hbCBpbXBsZW1lbnRhdGlvbiBvZiB0aGlz LCBzbyBpdCB3YXMgbWV0CndpdGggYSBub3Qtc3VwcG9ydGVkIGVycm9yLiAgVGhpcyBhZGRzIHRo ZSBpbnRlcm5hbCBpbXBsZW1lbnRhdGlvbiBhbmQKcmVtb3ZlcyB0aGUgZXJyb3IuICBUaGUgaW1w bGVtZW50YXRpb24gZm9sbG93cyB0aGUgc3BlY2lmaWNhdGlvbiBvZgp0aGUgU1FMIHN0YW5kYXJk IGZvciB0aGlzLgoKVW5saWtlIHdpdGggZGV0ZXJtaW5pc3RpYyBjb2xsYXRpb25zLCB0aGUgTElL RSBtYXRjaGluZyBjYW5ub3QgZ28KY2hhcmFjdGVyIGJ5IGNoYXJhY3RlciBidXQgaGFzIHRvIGdv IHN1YnN0cmluZyBieSBzdWJzdHJpbmcuICBGb3IKZXhhbXBsZSwgaWYgd2UgYXJlIG1hdGNoaW5n IGFnYWluc3QgTElLRSAnZm9vJWJhcicsIHdlIGNhbid0IHN0YXJ0IGJ5Cmxvb2tpbmcgZm9yIGFu ICdmJywgdGhlbiBhbiAnbycsIGJ1dCBpbnN0ZWFkIHdpdGggaGF2ZSB0byBmaW5kCnNvbWV0aGlu ZyB0aGF0IG1hdGNoZXMgJ2ZvbycuICBUaGlzIGlzIGJlY2F1c2UgdGhlIGNvbGxhdGlvbiBjb3Vs ZApjb25zaWRlciBzdWJzdHJpbmdzIG9mIGRpZmZlcmVudCBsZW5ndGhzIHRvIGJlIGVxdWFsLiAg VGhpcyBpcyBhbGwKaW50ZXJuYWwgdG8gTWF0Y2hUZXh0KCkgaW4gbGlrZV9tYXRjaC5jLgoKVGhl IGNoYW5nZXMgaW4gR2VuZXJpY01hdGNoVGV4dCgpIGluIGxpa2UuYyBqdXN0IHBhc3MgdGhyb3Vn aCB0aGUKbG9jYWxlIGluZm9ybWF0aW9uIHRvIE1hdGNoVGV4dCgpLCB3aGljaCB3YXMgcHJldmlv dXNseSBub3QgbmVlZGVkLgpUaGlzIG1hdGNoZXMgZXhhY3RseSBHZW5lcmljX1RleHRfSUNfbGlr ZSgpIGJlbG93LgoKSUxJS0UgaXMgbm90IGFmZmVjdGVkLiAgKEl0J3MgdW5jbGVhciB3aGV0aGVy IElMSUtFIG1ha2VzIHNlbnNlIHVuZGVyCm5vbmRldGVybWluaXN0aWMgY29sbGF0aW9ucy4pCgpU aGlzIGFsc28gdXBkYXRlcyBtYXRjaF9wYXR0ZXJuX3ByZWZpeCgpIGluIGxpa2Vfc3VwcG9ydC5j IHRvIHN1cHBvcnQKb3B0aW1pemluZyB0aGUgY2FzZSBvZiBhbiBleGFjdCBwYXR0ZXJuIHdpdGgg bm9uZGV0ZXJtaW5pc3RpYwpjb2xsYXRpb25zLiAgVGhpcyB3YXMgYWxyZWFkeSBhbGx1ZGVkIHRv IGluIHRoZSBwcmV2aW91cyBjb2RlLgoKKGluY2x1ZGVzIGRvY3VtZW50YXRpb24gZXhhbXBsZXMg ZnJvbSBEYW5pZWwgVsOpcml0w6kgYW5kIHRlc3QgY2FzZXMKZnJvbSBQYXVsIEEgSnVuZ3dpcnRo KQoKUmV2aWV3ZWQtYnk6IEppYW4gSGUgPGppYW4udW5pdmVyc2FsaXR5QGdtYWlsLmNvbT4KRGlz Y3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9mbGF0LzcwMGQy ZTg2LWJmNzUtNDYwNy05Y2YyLWY1Yjc4MDJmNmU4OEBlaXNlbnRyYXV0Lm9yZwoKQnJhbmNoCi0t LS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmLzg1YjdlZmExY2RkNjNjMmZlMmI3MGI3MjViODI4NTc0M2VlNTc4N2YKCk1v ZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jaGFyc2V0LnNnbWwgICAg ICAgICAgICAgICAgICAgICAgfCAgIDIgKy0KZG9jL3NyYy9zZ21sL2Z1bmMuc2dtbCAgICAgICAg ICAgICAgICAgICAgICAgICB8ICA1MiArKysrKystCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9saWtl LmMgICAgICAgICAgICAgICAgICAgfCAgMjYgKystLQpzcmMvYmFja2VuZC91dGlscy9hZHQvbGlr ZV9tYXRjaC5jICAgICAgICAgICAgIHwgMTQ5ICsrKysrKysrKysrKysrKysrKy0Kc3JjL2JhY2tl bmQvdXRpbHMvYWR0L2xpa2Vfc3VwcG9ydC5jICAgICAgICAgICB8ICAyOSArKy0tCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvY29sbGF0ZS5pY3UudXRmOC5vdXQgfCAxODkgKysrKysrKysrKysr KysrKysrKysrKysrLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jb2xsYXRlLmljdS51dGY4LnNxbCAg ICAgIHwgIDU1ICsrKysrKy0KNyBmaWxlcyBjaGFuZ2VkLCA0NTggaW5zZXJ0aW9ucygrKSwgNDQg ZGVsZXRpb25zKC0pCgo= --===============3416072406886485035==--