Henry House <hajhouse(at)houseag(dot)com> writes:
>> Unfortunately you didn't mention anything about your locale setup...
> The server locale is en_US.UTF-8. (At least I set it up as such when
> installing PostgreSQL; I know no way to verify.) The server version is 7.2.=
> 1,
> running on a IA32 and a DEC Alpha; both machines show the same behavior. Bo=
> th
> are Debian Linux. Perhaps the bug lies in the locale definition supplied by
> Debian?
Offhand I'd not necessarily expect an en_US locale to upcase/downcase
anything except a-z/A-Z. Perhaps you need to use a different locale.
I'd suggest taking this up with a locale expert, which I surely am
not.
regards, tom lane