BUG #3433: regexp \m and \M don't work for cyrillic

From: "Andriy Rysin" <arysin(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3433: regexp \m and \M don't work for cyrillic
Date: 2007-07-07 00:20:24
Message-ID: 200707070020.l670KOnp075994@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3433
Logged by: Andriy Rysin
Email address: arysin(at)gmail(dot)com
PostgreSQL version: 8.2.4
Operating system: Linux
Description: regexp \m and \M don't work for cyrillic
Details:

psql krym
krym=> \encoding
UTF8
krym=> create table test (txt varchar);
CREATE TABLE
krym=> insert into test values ('latin');
INSERT 0 1
krym=> insert into test values ('');
INSERT 0 1
krym=> select * from test;
txt
----------
latin

(2 rows)

krym=> select * from test where txt ~* E'\\mla';
txt
-------
latin
(1 row)

krym=> select * from test where txt ~* E'\\m';
txt
-----
(0 rows)

escaping specials in regular expressions \m and \M for beginning of word and
end of word work for latin symbols bug don't for cyrillic

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-07-07 15:30:56 Re: BUG #3433: regexp \m and \M don't work for cyrillic
Previous Message Rainer Bauer 2007-07-06 19:55:10 Re: BUG #3427: Autovacuum crashed server