Re: Disabling case sensitivity - Mailing list pgsql-general

Stephan Szabo wrote:
>
> On Thu, 11 Jul 2002, ktt wrote:
>
> >
> > That's a problem, because I building
> > a UNICODE text database and planning case insensitive
> > search.
>
> You can do case insensitive searches as long as you're
> willing to use something other than var=literal (such
> as tolower(var)=lowerliteral or tolower(var)=tolower(literal)
> or var ILIKE literal).
>

If your general search is case insensitive, remeber you can use functional
indices to improve performance.

    CREATE INDEX foo ON bar( upper(qux) );