pgsql-bugs@postgresql.org writes:
> i tried to do a select on some columns case insensitive.
> some charachters like äöü.. the ilike,~~*,upper made mistakes
Sounds like you didn't initialize the database with the right locale
setting.
regards, tom lane