Peter Eisentraut <peter_e@gmx.net> writes:
> Markus Bertheau wrote:
>> oocms=# select 'Ñ' ~ '^\\w$';
>> ?column?
>> ----------
>> f
>> (1 запиÑÑ)
> What locale are you using for LC_COLLATE? If it's C or POSIX, you need
> to change it and re-initdb.
Another likely cause of trouble is that the regexp character
classification stuff is presently based on <ctype.h> functions and thus
cannot work in multibyte encodings.
regards, tom lane