RE: AW: German "umlaut insensitive" query
"Voillequin, Jean-Marc" <[email protected]> Tue, 24 Sep 2019 10:10:08 +0000
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <BYAPR20MB26140531FB0138F4C49F54DABE840@BYAPR20MB2614.namprd20.prod.outlook.com> |
SGVsbG8sDQoNClNFVCBjb21tYW5kIGRvZXMgbm90IHdvcmsgYXMgeW91IGV4cGVjdCBpbiBQTFBH U1FMLiBUaGUgX3RpbWVvdXQgYXJndW1lbnQgaXMgdW5kZXJzdG9vZCBhcyBhIHRoZSBuZXcgdmFs dWUgKG5vdCB0aGUgY29udGVudCBvZiBfdGltZW91dCkuDQpVc2Ugc2V0X2NvbmZpZyBmdW5jdGlv biBpbnN0ZWFkLg0KDQpDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBwdWJsaWMuc2V0X3RyYW5z ZmVyKF9pZCBpbnRlZ2VyLCAgX3RhYmxlbmFtZSBjaGFyYWN0ZXIgdmFyeWluZywgX3RpbWVvdXQg Y2hhcmFjdGVyIHZhcnlpbmcpDQogUkVUVVJOUyB2b2lkDQogTEFOR1VBR0UgcGxwZ3NxbA0KQVMg JGZ1bmN0aW9uJA0KYmVnaW4NCiAgcGVyZm9ybSBzZXRfY29uZmlnKCdpZGxlX2luX3RyYW5zYWN0 aW9uX3Nlc3Npb25fdGltZW91dCcsX3RpbWVvdXQsZmFsc2UpOw0KZW5kOyRmdW5jdGlvbiQNCjsN Cg0KUmVnYXJkcw0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogSmFrb2IuV2l0 Y3pha0BkbHIuZGUgPEpha29iLldpdGN6YWtAZGxyLmRlPiANClNlbnQ6IFR1ZXNkYXksIFNlcHRl bWJlciAyNCwgMjAxOSAxMDozOCBBTQ0KVG86IHBldGVyLmVpc2VudHJhdXRAMm5kcXVhZHJhbnQu Y29tDQpDYzogcGdzcWwtc3FsQHBvc3RncmVzcWwub3JnOyBqb25hdGhhbi5rYXR6QGV4Y292ZW50 dXJlcy5jb20NClN1YmplY3Q6IEFXOiBBVzogR2VybWFuICJ1bWxhdXQgaW5zZW5zaXRpdmUiIHF1 ZXJ5DQoNClN1cGVyLCB0aGFuayB5b3Ugc28gbXVjaCBmb3IgdGhlIHRpcC4NCg0KSSBzdGlsbCBo YXZlIGEgbGl0dGxlIHByb2JsZW0gd2hlcmUgSSBkb24ndCBnZXQgZmFyIDstKQ0KDQpJIGNvbnN0 YW50bHkgZ2V0IGFuIGVycm9yIG1lc3NhZ2Ugd2hlbiBJIGdpdmUgdGhlIFNFVCBhIHZhbHVlLg0K U2llaGUgdW50ZW4uDQoNCkVSUk9SOiBFUlJPUjogaW52YWxpZCB2YWx1ZSBmb3IgcGFyYW1ldGVy ICJpZGxlX2luX3RyYW5zYWN0aW9uX3Nlc3Npb25fdGltZW91dCI6ICJfdGltZW91dCIgQ09OVEVY VDogU1FMIHN0YXRlbWVudCAiU0VUIGlkbGVfaW5fdHJhbnNhY3Rpb25fc2Vzc2lvbl90aW1lb3V0 IFRPIF90aW1lb3V0IiBQTC9wZ1NRTCBmdW5jdGlvbiBzZXRfdHJhbnNmZXIoaW50ZWdlcixjaGFy YWN0ZXIgdmFyeWluZyxjaGFyYWN0ZXIgdmFyeWluZykgTGluZSA0IGF0IFNFVCBTUUwgc3RhdGU6 IDIyMDIzU0VMRUNUICogRlJPTSANCg0KQ2FsbCBmdW5jdGlvbjoNCnNldF90cmFuc2Zlcig4Nywn dXNlcnMnLCc1MDAwJyk7DQoNCg0KRnVuY3Rpb246DQoNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNU SU9OIHB1YmxpYy5zZXRfdHJhbnNmZXIoX2lkIGludGVnZXIsICBfdGFibGVuYW1lIGNoYXJhY3Rl ciB2YXJ5aW5nLCBfdGltZW91dCBjaGFyYWN0ZXIgdmFyeWluZykNCiAgIFJFVFVSTlMgU0VUT0Yg dXNlcnMNCiAgIExBTkdVQUdFICdwbHBnc3FsJ0FTICRCT0RZJA0KQkVHSU4NCiAgU0VUIGlkbGVf aW5fdHJhbnNhY3Rpb25fc2Vzc2lvbl90aW1lb3V0IFRPIF90aW1lb3V0OyAuLi4uLi4NCkVORA0K DQoNCkkndmUgdHJpZWQgYWxtb3N0IGV2ZXJ5dGhpbmcuIDotKCANCg0KDQpCZXN0IFJlZ2FyZHMN Ckpha29iDQoNCg0KDQoNCg0KLS0tLS1VcnNwcsO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9u OiBQZXRlciBFaXNlbnRyYXV0IFttYWlsdG86cGV0ZXIuZWlzZW50cmF1dEAybmRxdWFkcmFudC5j b21dDQpHZXNlbmRldDogRGllbnN0YWcsIDI0LiBTZXB0ZW1iZXIgMjAxOSAwOTowNQ0KQW46IFdp dGN6YWssIEpha29iOyBqb25hdGhhbi5rYXR6QGV4Y292ZW50dXJlcy5jb20NCkNjOiBwZ3NxbC1z cWxAcG9zdGdyZXNxbC5vcmcNCkJldHJlZmY6IFJlOiBBVzogR2VybWFuICJ1bWxhdXQgaW5zZW5z aXRpdmUiIHF1ZXJ5DQoNCk9uIDIwMTktMDktMjMgMDc6NTcsIEpha29iLldpdGN6YWtAZGxyLmRl IHdyb3RlOg0KPiBUaGFua3MgZm9yIHRoZSBxdWljayBhbnN3ZXIuIEkgYW0gbG9va2luZyBmb3J3 YXJkIHRvIHRoZSBuZXcgDQo+IFBvc3RncmVzU1FMIHZlcnNpb24uIFRoYW5rcw0KDQpJbiB0aGUg bWVhbnRpbWUsIHRoZSB1bmFjY2VudCBjb250cmliIG1vZHVsZSBjYW4gYWxzbyBoZWxwLg0KDQot LSANClBldGVyIEVpc2VudHJhdXQgICAgICAgICAgICAgIGh0dHA6Ly93d3cuMm5kUXVhZHJhbnQu Y29tLw0KUG9zdGdyZVNRTCBEZXZlbG9wbWVudCwgMjR4NyBTdXBwb3J0LCBSZW1vdGUgREJBLCBU cmFpbmluZyAmIFNlcnZpY2VzDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQoKTW9vZHkncyBtb25pdG9ycyBlbWFpbCBjb21tdW5pY2F0aW9ucyB0aHJvdWdoIGl0cyBu ZXR3b3JrcyBmb3IgcmVndWxhdG9yeSBjb21wbGlhbmNlIHB1cnBvc2VzIGFuZCB0byBwcm90ZWN0 IGl0cyBjdXN0b21lcnMsIGVtcGxveWVlcyBhbmQgYnVzaW5lc3MgYW5kIHdoZXJlIGFsbG93ZWQg dG8gZG8gc28gYnkgYXBwbGljYWJsZSBsYXcuIFRoZSBpbmZvcm1hdGlvbiBjb250YWluZWQgaW4g dGhpcyBlLW1haWwgbWVzc2FnZSwgYW5kIGFueSBhdHRhY2htZW50IHRoZXJldG8sIGlzIGNvbmZp ZGVudGlhbCBhbmQgbWF5IG5vdCBiZSBkaXNjbG9zZWQgd2l0aG91dCBvdXIgZXhwcmVzcyBwZXJt aXNzaW9uLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50IG9yIGFuIGVtcGxv eWVlIG9yIGFnZW50IHJlc3BvbnNpYmxlIGZvciBkZWxpdmVyaW5nIHRoaXMgbWVzc2FnZSB0byB0 aGUgaW50ZW5kZWQgcmVjaXBpZW50LCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0IHlvdSBo YXZlIHJlY2VpdmVkIHRoaXMgbWVzc2FnZSBpbiBlcnJvciBhbmQgdGhhdCBhbnkgcmV2aWV3LCBk aXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24gb3IgY29weWluZyBvZiB0aGlzIG1lc3NhZ2UsIG9y IGFueSBhdHRhY2htZW50IHRoZXJldG8sIGluIHdob2xlIG9yIGluIHBhcnQsIGlzIHN0cmljdGx5 IHByb2hpYml0ZWQuIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgbWVzc2FnZSBpbiBlcnJvciwg cGxlYXNlIGltbWVkaWF0ZWx5IG5vdGlmeSB1cyBieSB0ZWxlcGhvbmUsIGZheCBvciBlLW1haWwg YW5kIGRlbGV0ZSB0aGUgbWVzc2FnZSBhbmQgYWxsIG9mIGl0cyBhdHRhY2htZW50cy4gRXZlcnkg ZWZmb3J0IGlzIG1hZGUgdG8ga2VlcCBvdXIgbmV0d29yayBmcmVlIGZyb20gdmlydXNlcy4gWW91 IHNob3VsZCwgaG93ZXZlciwgcmV2aWV3IHRoaXMgZS1tYWlsIG1lc3NhZ2UsIGFzIHdlbGwgYXMg YW55IGF0dGFjaG1lbnQgdGhlcmV0bywgZm9yIHZpcnVzZXMuIFdlIHRha2Ugbm8gcmVzcG9uc2li aWxpdHkgYW5kIGhhdmUgbm8gbGlhYmlsaXR5IGZvciBhbnkgY29tcHV0ZXIgdmlydXMgd2hpY2gg bWF5IGJlIHRyYW5zZmVycmVkIHZpYSB0aGlzIGUtbWFpbCBtZXNzYWdlLgoKVGhpcyBlbWFpbCB3 YXMgc2VudCB0byB5b3UgYnkgTW9vZHnigJlzIEludmVzdG9ycyBTZXJ2aWNlIEVNRUEgTGltaXRl ZApSZWdpc3RlcmVkIG9mZmljZSBhZGRyZXNzOgpPbmUgQ2FuYWRhIFNxdWFyZQpDYW5hcnkgV2hh cmYKTG9uZG9uLCBFMTQgNUZBClJlZ2lzdGVyZWQgaW4gRW5nbGFuZCBhbmQgV2FsZXMgTm86IDg5 MjI3MDEKCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCg==