=?UTF-8?Q?Filip_Rembia=C5=82kowski?= <plk(dot)zuber(at)gmail(dot)com> writes:
> I have a problem with locale on windows.
> postgresql 8.4.
> this does not work as expected:
> filip=# select 'A' ~ '\w', '' ~ '\w';
The locale-aware regex operators don't really work in multibyte
encodings. There's a (partial) fix for this in 9.0, but we don't
trust it yet so it's not been back-patched.
regards, tom lane