\w doesn't match non-ASCII letters

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: \w doesn't match non-ASCII letters
Date: 2004-06-14 14:56:16
Message-ID: 1087224976.3229.4.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

oocms=# select 'ф' ~ '^\\w$';
?column?
----------
f
(1 запись)

or

oocms=# select 'ä' ~ '^\\w$';
?column?
----------
f
(1 запись)

both should return true, as does

oocms=# select 'n' ~ '^\\w$';
?column?
----------
t
(1 запись)

Thanks.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2004-06-14 15:15:37 Re: \w doesn't match non-ASCII letters
Previous Message Stephan Szabo 2004-06-14 01:30:43 Re: BUG #1162: lots of values that have "unique" property