BUG #5220: regexp fails on punctuation characters
The following bug has been logged online:
Bug reference: 5220
Logged by: jef peeraer
Email address: jef.peeraer@telenet.be
PostgreSQL version: 8.3
Operating system: linux
Description: regexp fails on punctuation characters
Details:
my lc_locale is set to en_US.UTF-8
if i do a search like this
select * from contacten
where naam ~* 'RÖN'
and my contacten table contains a column naam with the value
RÖNTGEN TECHNISCHE DIENST NV
-> it won't find it
the same query with
naam ILIKE '%RÖN%' works perfectly
"jef peeraer" <jef.peeraer@telenet.be> writes:
my lc_locale is set to en_US.UTF-8
if i do a search like this
select * from contacten
where naam ~* 'RÖN'
and my contacten table contains a column naam with the value
RÖNTGEN TECHNISCHE DIENST NV
-> it won't find it
Works for me.
It is true that ~* isn't very good about upper/lower case matching
for non-ASCII letters, but that doesn't seem to apply to your
example.
regards, tom lane