Re: [ADMIN] About lower and uppercase

Date: Tue, 05 Nov 2002 09:22:37 +0100
From: frbn <frbn(at)efbs-seafrigo(dot)fr>
>
> select * from fruits where fruit_name ~* 'orange';
>
Does this query ever use an index on fruit_name?

AFAIK the most reliant solution is the previously suggested
"where lower(fruit_name) = 'orange'"
AND creating indices only on lower(attributename).

Beware however that there are some letters that have no
uppercase/lowercase equivalent (the letter "Eszet" (ß) in German
is an example for a letter that has no uppercase equivalent).
That should not be such an issue as a proper implementation of
upper()/lower() would leave these letters alone.

Christoph Dalitz