Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 6EE354248
	for <pgsql-sql@postgresql.org>; Thu, 22 Mar 2012 17:26:29 -0300 (ADT)
Received: from smtp.comsquared.com ([209.155.237.140])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <erouse@comsquared.com>) id 1SAoaa-0004DU-9S
	for pgsql-sql@postgresql.org; Thu, 22 Mar 2012 20:26:28 +0000
Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1])
	by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id
	q2MKQAxH010876
	for <pgsql-sql@postgresql.org>; Thu, 22 Mar 2012 16:26:13 -0400 (EDT)
Received: from erouse052008 ([10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	q2MKQAxD025249
	for <pgsql-sql@postgresql.org>; Thu, 22 Mar 2012 16:26:10 -0400 (EDT)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: <pgsql-sql@postgresql.org>
Subject: ignore case in where clause
Date: Thu, 22 Mar 2012 16:26:09 -0400
Message-ID: <06fe01cd086a$04681ce0$0d3856a0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: Ac0IagQLrBSg4tc3RKOrCPIjdU7RGA==
Content-Language: en-us
X-Pg-Spam-Score: -0.0 (/)
X-Archive-Number: 201203/60
X-Sequence-Number: 36455

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