Re: Disabling case sensitivity - Mailing list pgsql-general

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).