Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DB9BA476E52 for ; Thu, 26 Sep 2002 13:54:40 -0400 (EDT) Received: from jupiter2.breezing.com (jupiter.breezing.com [63.172.201.30]) by postgresql.org (Postfix) with ESMTP id 0503E476E4C for ; Thu, 26 Sep 2002 13:54:40 -0400 (EDT) Received: by jupiter2.breezing.com from localhost (router,SLMail V5.0); Thu, 26 Sep 2002 13:46:46 -0400 for Received: from [63.172.201.5] [63.172.201.5] by jupiter2.breezing.com [63.172.201.30] (SLmail 5.0.0.4342) with ESMTP id 69A77887F6444C56AC96696FE45026C6 for ; Thu, 26 Sep 2002 13:46:45 -0400 Mime-Version: 1.0 X-Sender: jordan@jupiter.breezing.com Message-Id: Date: Thu, 26 Sep 2002 13:54:41 -0400 To: pgsql-sql@postgresql.org From: Jordan Reiter Subject: Case Sensitive "WHERE" Clauses? Content-Type: text/plain; charset="us-ascii" X-SLUIDL: 55B3919F-87A048C0-877FB6EA-EF49BF6E X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/330 X-Sequence-Number: 9607 Are string comparisons in postgresql case sensitive? I keep on having this response: SELECT * FROM People WHERE first_name='jordan' Result: 0 records SELECT * FROM People WHERE first_name='Jordan' Result: 1 record I though that string matching in SQL was case-insensitive. Isn't this correct? If not, what workarounds have been used successfully before? Obviously, formatting the search string for the query is not a solution... -- Jordan Reiter mailto:jordan@breezing.com Breezing.com http://breezing.com 1106 West Main St phone:434.295.2050 Charlottesville, VA 22903 fax:603.843.6931