"Ragnar Österlund" <ragoster@gmail.com> writes:
> I'm not sure if this is a bug or if I'm doing something wrong. I have
> a database encoded with ISO-8859-1, aka LATIN1. When I do something
> like:
> SELECT '�' ~* '�';
> it returns false.
Check the database's locale setting (LC_CTYPE). It has to be one that
expects LATIN1 encoding.
The current regex code is generally not able to deal with locale-specific
behaviors in UTF8 encoding, but it should work for single-byte encodings
as long as you've got the locale setting right.
regards, tom lane