Sergey Levchenko <sector119(at)gmail(dot)com> writes:
> I am not able to get work lower and upper functions on postgresql
> v8.0.1 and 8.1b(current cvs copy). I use Debian SID i686 GNU/Linux.
> Locale: ru_RU.KOI8-R
> createdb -E UNICODE test
I think the problem is you selected a database encoding that doesn't
match what the locale expects. You can't really mix-and-match if you
expect locale-specific stuff like upper/lower to work. For that
locale you must use -E KOI8.
regards, tom lane