"scott.marlowe" <scott.marlowe@ihs.com> writes:
> Is there a case insensitive locale? Or is that even possible?
It's certainly possible, but I don't know of any standard locales that
behave like that.
One could also imagine developing a new set of comparison operators that
do case-insensitive comparison, and then making a special index opclass
for that. The locale-insensitive operators Peter built to optimize LIKE
indexing in 7.4 would be a good model.
regards, tom lane