On Thu, 2012-03-22 at 16:26 -0400, Edward W. Rouse wrote:
> I am currently using lower(column) = '' for matching case insensitive. I
> know that there are ways to do this with regular expressions too. I recently
> noticed that including even one lower causes severe performance issues (from
> 290ms to over 80Kms).
Probably because it cannot use the index anymore. Try creating an index
on lower(column), and see if it helps.
In response to
pgsql-sql by date
|Next:||From: Edward W. Rouse||Date: 2012-03-22 21:05:41|
|Subject: Re: ignore case in where clause|
|Previous:||From: Edward W. Rouse||Date: 2012-03-22 20:26:09|
|Subject: ignore case in where clause|