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 1jJo0E-0003lu-OF for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Apr 2020 00:46:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJo0D-0006zZ-Bk for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Apr 2020 00:46:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJmlH-0002Qf-Pd for pgsql-bugs@lists.postgresql.org; Wed, 01 Apr 2020 23:27:07 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJmlD-0004Ds-F9 for pgsql-bugs@lists.postgresql.org; Wed, 01 Apr 2020 23:27:07 +0000 Content-Type: multipart/mixed; boundary="===============3915268917329330632==" MIME-Version: 1.0 Subject: BUG #16333: position() function not equivalent to strpos() function when comparing citext To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: me@reynolds.tj Reply-To: me@reynolds.tj, pgsql-bugs@lists.postgresql.org Date: Wed, 01 Apr 2020 23:26:29 +0000 Message-ID: <16333-dd25eea9d90e244d@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3915268917329330632== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjMzMwpMb2dnZWQgYnk6ICAgICAgICAgIFR5bGVyIFJleW5vbGRzCkVt YWlsIGFkZHJlc3M6ICAgICAgbWVAcmV5bm9sZHMudGoKUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjYu MTcKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwCkRlc2NyaXB0aW9uOiAgICAgICAgCgpU byByZXByb2R1Y2U6DQoNCkNSRUFURSBEQVRBQkFTRSB0ZXN0Ow0KQ1JFQVRFIEVYVEVOU0lPTiBj aXRleHQ7DQoNClNFTEVDVCBwb3NpdGlvbignZm9vJzo6Y2l0ZXh0IElOICdGb29iYXInOjpjaXRl eHQpID0Kc3RycG9zKCdGb29iYXInOjpjaXRleHQsICdmb28nOjpjaXRleHQpIGFzICJwb3NpdGlv bkVxdWFsc1N0cnBvcyI7DQoNCkV4cGVjdGVkOiAicG9zaXRpb25FcXVhbHNTdHJwb3MiIHJldHVy bnMgVFJVRS4NCkFjdHVhbDogInBvc2l0aW9uRXF1YWxzU3RycG9zIiByZXR1cm5zIEZBTFNFLg0K DQpDaXRleHQgZG9lcyBub3QgY3JlYXRlIGFuIG92ZXJsb2FkIGZvciBwb3NpdGlvbigpIHN1cHBv cnRpbmcgY2l0ZXh0CnBhcmFtZXRlcnMsIHRoZXJlZm9yZSBwb3NpdGlvbihhIGluIGIpIGFsd2F5 cyBydW5zIGNhc2Utc2Vuc2l0aXZlLgoK --===============3915268917329330632==--