Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A0D834762EE for ; Thu, 26 Sep 2002 23:20:07 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id F27F1476199 for ; Thu, 26 Sep 2002 23:20:06 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g8R3JihR020456; Thu, 26 Sep 2002 23:19:44 -0400 (EDT) To: Ian Barwick Cc: Chris , pgsql-sql@postgresql.org Subject: Re: Case Sensitive "WHERE" Clauses? In-reply-to: <200209270133.35024.barwick@gmx.net> References: <5.1.0.14.0.20020927090709.02f125d0@cooee.squiz.net> <200209270133.35024.barwick@gmx.net> Comments: In-reply-to Ian Barwick message dated "Fri, 27 Sep 2002 01:33:35 +0200" Date: Thu, 26 Sep 2002 23:19:43 -0400 Message-ID: <20455.1033096783@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/351 X-Sequence-Number: 9628 Ian Barwick writes: > Anyone know what the ANSI standard is? I don`t recall any other > database apart from MySQL which default to case-insensitive > CHAR or VARCHAR columns. I believe the spec has a notion of a "collation attribute" attached to character-type columns. You could define a collation that makes comparisons case insensitive and then mark selected columns that way. We don't have anything like that yet, though Tatsuo has been heard muttering about how to make it happen ... regards, tom lane