Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nK2Oc-0002RM-Aq for pgsql-docs@arkaria.postgresql.org; Tue, 15 Feb 2022 18:17:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nK2Ob-00075H-7t for pgsql-docs@arkaria.postgresql.org; Tue, 15 Feb 2022 18:17:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nK0Wl-0006uE-3R for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 16:18:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nK0Wi-0001Hl-Eo for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 16:18:05 +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=Tm7N8W7j3pJCtlywUGlM8hhjWcLTo+In/tHtT1N7eFk=; b=SRVrFpMSHgFP/juAdvzmloon2m eY1SjSGY+gffBwkMX7ZzItIzmYQznvUy0PnuEgGIDYe8fV1CYLeAiniSza3R4vZ08iw+YW+Zv+DX5 bce3hs6cR7FNFpX9YCPvkC/A8yIHsUE2qNSPLVO3XjoZdqrFq6Cw9Iys/b/Yg6u5asSRdLChgnq1p B+J+C6/EQJr8PApWmyi/dqXtTHZQCdwcZmVHBbMfU8FwEzfgSk5MgHJsabRgCEs2iYtgcde0tbCeB VsrX0EqZm7+vuapv5nkmlHXtSRjoWntR7CZVd6BcHlmi2o4GhvXvzvd3Vg5CmMZHHeov3/XL500+S +4Y6HJKw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nK0Wh-0002xY-QM for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 16:18:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nK0Wg-0006bL-Nf for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 16:18:02 +0000 Content-Type: multipart/mixed; boundary="===============7105910516088730333==" MIME-Version: 1.0 Subject: Does the POSITION() function takes into account the COLLATION... or not ?!? To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: pageorge@unice.fr Reply-To: pageorge@unice.fr, pgsql-docs@lists.postgresql.org Date: Tue, 15 Feb 2022 16:17:53 +0000 Message-ID: <164494187300.23318.373331246819207718@wrigleys.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 --===============7105910516088730333== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNC9mdW5j dGlvbnMtc3RyaW5nLmh0bWwKRGVzY3JpcHRpb246CgpUaGUgZG9jIGRvZXNuJ3Qgc2F5IGFueXRo aW5nIGFib3V0IHRoZSBpbXBhY3Qgb2YgdGhlIENPTExBVElPTiBvbiB0aGUKcmVzdWx0cyBvZiBh bnkgb2YgdGhlIHN0cmluZyBmdW5jdGlvbnMsIHNvIEkgdHJpZWQgc29tZSBpbnRlcmVzdGluZyB0 ZXN0cwp3aXRoIFBPU0lUSU9OKCk6DQoNClNFTEVDVCBQT1NJVElPTigoJ8OfJyBDT0xMQVRFICJk ZV9ERS51dGY4IikgSU4gJ0RBU1MnKTsgLS0gc2hvdWxkIHJldHVybiAzCmluc3RlYWQgb2YgMCAh PyENClNFTEVDVCBQT1NJVElPTigoJ3NzJyBDT0xMQVRFICJkZV9ERS51dGY4IikgSU4gJ2Rhw58n KTsgLS0gc2hvdWxkIHJldHVybiAzCmluc3RlYWQgb2YgMCAhPyENCg0KU0VMRUNUIFBPU0lUSU9O KCgnb2UnIENPTExBVEUgImZyX0ZSLnV0ZjgiKSBJTiAnYsWTdWYnKTsgLS0gc2hvdWxkIHJldHVy biAyCmluc3RlYWQgb2YgMCAhPyENClNFTEVDVCBQT1NJVElPTigoJ8WTJyBDT0xMQVRFICJmcl9G Ui51dGY4IikgSU4gJ2JvZXVmJyk7IC0tIHNob3VsZCByZXR1cm4gMgppbnN0ZWFkIG9mIDAgIT8h DQoNClNFTEVDVCBQT1NJVElPTigoJ8OlJyBDT0xMQVRFICJlbl9VUy51dGY4IikgSU4gJ3llYWgn KTsgLS0gc2hvdWxkIHJldHVybiAzCmluc3RlYWQgb2YgMCAhPyENClNFTEVDVCBQT1NJVElPTigo J28nIENPTExBVEUgImVuX1VTLnV0ZjgiKSBJTiAnw6VuZ3N0csO2bScpOyAtLSBzaG91bGQgcmV0 dXJuCjcgaW5zdGVhZCBvZiAwICE/IQ0KDQo9PT4gdXAgdG8gaGVyZSwgdGhpcyBzZWVtcyBwcmV0 dHkgZW5vdWdoIHRvIGNvbmNsdWRlIHRoYXQgUE9TSVRJT04oKSBkb2Vzbid0CmNhcmUgYXQgYWxs IGFib3V0IENPTExBVElPTiBhbmQgYWx3YXlzIHBlcmZvcm0gYSBieXRlIHNlYXJjaC4NCg0KTm93 IHRoZSBncmVhdCBzdXJwcmlzZSBjb21lcyAhLi4uDQoNCkNSRUFURSBDT0xMQVRJT04gcHVibGlj LmNhc2VfYW5kX2FjY2VudF9pbnNlbnNpdGl2ZSAoDQogICAgICBwcm92aWRlciA9IGljdSwgDQog ICAgICBsb2NhbGUgPSAndW5kLXUta3MtbGV2ZWwxJywgDQogICAgICBkZXRlcm1pbmlzdGljID0g ZmFsc2UNCiAgICApOw0KU0VMRUNUIFBPU0lUSU9OKCgnbycgQ09MTEFURSBwdWJsaWMuY2FzZV9h bmRfYWNjZW50X2luc2Vuc2l0aXZlKSBJTgonw6VuZ3N0csO2bScpOyANCg0KPT4gZ2l2ZXMgRVJS T1I6ICJub25kZXRlcm1pbmlzdGljIGNvbGxhdGlvbnMgYXJlIG5vdCBzdXBwb3J0ZWQgZm9yIHN1 YnN0cmluZwpzZWFyY2hlcyINCg0KRG9lcyB0aGUgUE9TSVRJT04oKSBmdW5jdGlvbiBwcmV0ZW5k cyB0YWtpbmcgaW50byBhY2NvdW50IHRoZSBDT0xMQVRJT04gPz8Kb3Igbm90ID8/DQoNCi0gSWYg bm90LCB0aGVuIHdoeSB0aGUgaGVsbCBpcyB0aGVyZSB0aGlzIGVycm9yIG1lc3NhZ2UgYWJvdXQK bm9uZGV0ZXJtaW5pc3RpYyBjb2xsYXRpb25zIHdoaWxlIHRoZSBQT1NJVElPTigpIGRvZXNuJ3Qg Y2FyZSBhdCBhbGwgYWJvdXQKdGhlIENPTExBVElPTi4uLg0KCC0gSWYgeWVzLCB0aGVuIHRoZSBm aXJzdCA2IGxpbmVzIG9mIFNRTCBhYm92ZSBhcmUgcmV0dXJuaW5nIHRoZSB3cm9uZwp2YWx1ZS4u LiAoYXJlIHRoZXJlIGFueSBzcGVjaWZpYyB0ZWNobmljYWwgbGltaXRhdGlvbnMgaGVyZSA/KQ0K DQpJIHdvdWxkIGxpa2UgdG8gaGF2ZSBzb21ldGhpbmcgaW4gdGhlIGRvYyBhYm91dCB0aGF0Li4u IGkuZS4gZWl0aGVyIHNvbWUKZXhhbXBsZXMgc2hvd2luZyBob3cgdGhlIENPTExBVElPTiBpcyBp bXBhY3RpbmcgdGhlIHJlc3VsdHMgb2YgdGhlClBPU0lUSU9OKCkgZnVuY3Rpb24gOyBvciBhIHN0 YXRlbWVudCB3aGljaCBjb25maXJtcyB0aGF0IHRoZSBQT1NJVElPTigpCmZ1bmN0aW9uIGRvZXNu J3QgY2FyZSBhdCBhbGwgYWJvdXQgdGhlIENPTExBVElPTiAoKyB0aGUgYWR2aWNlIHRvCnN5c3Rl bWF0aWNhbGx5IGFkZCAuLi5DT0xMQVRFICJDIi4uLiBvbiBvbmUgb2YgdGhlIFBPU0lUSU9OKCkn cyBhcmd1bWVudHMgaW4Kb3JkZXIgdG8gYXZvaWQgdGhlIGR1bWIgIm5vbmRldGVybWluaXN0aWMg Y29sbGF0aW9ucyBhcmUgbm90IHN1cHBvcnRlZCIKZXJyb3IsIHdoaWxlIGluIGZpbmUgbm8gY29s bGF0aW9ucyBhdCBhbGwgYXJlIHN1cHBvcnRlZCkNCg0KVGhhbmtzLgo= --===============7105910516088730333==--