Postgres Pro
Downloads
Home   >   mailing lists

Re: ignore case in where clause - Mailing list pgsql-sql

From Guillaume Lelarge
Subject Re: ignore case in where clause
Date
Msg-id 1332448722.2339.10.camel@localhost.localdomain
Whole thread Raw
In response to ignore case in where clause  ("Edward W. Rouse" <erouse@comsquared.com>)
Responses Re: ignore case in where clause  ("Edward W. Rouse" <erouse@comsquared.com>)
List pgsql-sql
Tree view 
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.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

pgsql-sql by date:

Previous
From: "Edward W. Rouse"
Date:
Subject: ignore case in where clause
Next
From: "Edward W. Rouse"
Date:
Subject: Re: ignore case in where clause