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 case insensitive matching? I could spend a few hours testing if I have to, but I'm hoping someone knows off the top of their heads. Using 8.3 currently. I am a programmer, not a database person; but we don't really have a DB here, so I do what I can. Thanks. Edward W. Rouse Comsquared System, Inc. 770-734-5301 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
