Peter Eisentraut <peter_e(at)gmx(dot)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