BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8)

From: albert(dot)cieszkowski(at)cc(dot)com(dot)pl
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8)
Date: 2012-02-14 13:20:43
Message-ID: E1RxIJH-000504-Ti@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6457
Logged by: Albert Cieszkowski
Email address: albert(dot)cieszkowski(at)cc(dot)com(dot)pl
PostgreSQL version: 9.0.6
Operating system: CentOS 5.x
Description:

OS, base and client encoding UTF-8:

peimp=> select 'Świnoujście' ~* '\mŚwinoujście\M';
?column?
----------
f
(1 row)

peimp=> select 'Świnoujście' ~* '\AŚwinoujście\Z';
?column?
----------
t
(1 row)

but:

peimp=> select 'Mróz' ~* '\mmróZ\M';
?column?
----------
t
(1 row)

peimp=> select 'Mróz' ~* '\AmróZ\Z';
?column?
----------
t
(1 row)

I believe it is connected with bug #5766 and #3433.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-02-14 15:27:05 Re: BUG #6457: Regexp not processing word (with special characters on ends) correctly (UTF-8)
Previous Message Heikki Linnakangas 2012-02-14 12:41:14 Re: BUG #6452: psql: can't change client encoding from the command line