That was exactly it, Thanks.
> -Original Message-
> From: [email protected] [mailto:pgsql-sql-
> [email protected]] On Behalf Of Guillaume Lelarge
> Sent: Thursday, March 22, 2012 4:39 PM
> To: Edward W. Rouse
> Cc: [email protected]
> Subject:
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
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).
What is the best way, performance wise, to do cas
