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: Re: [SQL] ignore case in where clause > > 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 > > > -- > Sent via pgsql-sql mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql
-- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
