Received: from gyw.com (gyw.com [209.55.67.177]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4TGjpE89214 for ; Tue, 29 May 2001 12:45:51 -0400 (EDT) (envelope-from tjk@tksoft.com) Received: from smtp3.tksoft.com (smtp3.tksoft.com [192.168.50.56] (may be forged)) by gyw.com (8.8.8/8.8.8) with ESMTP id IAA16227; Tue, 29 May 2001 08:46:03 -0700 Received: (from tjk@tksoft.com) by smtp3.tksoft.com (8.8.8/8.8.8) id IAA23977; Tue, 29 May 2001 08:23:52 -0700 From: "tjk@tksoft.com" Message-Id: <200105291523.IAA23977@smtp3.tksoft.com> Subject: Re: Case Insensitive Queries To: mark@zserve.com (Mark) Date: Tue, 29 May 2001 08:23:52 -0700 (PDT) Cc: pgsql-sql@postgresql.org In-Reply-To: from "Mark" at May 29, 2001 09:11:23 AM X-Info: None MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/309 X-Sequence-Number: 3150 select * from account where lower(username) = lower('test'); Troy > > Is it possible to execute a query using a where clause that allows case > insensitive comparison between a field and text. > > For example: > > select * from account where username = 'test' > > where username could be 'Test', which would be a match. As is, this > compare is case sensitive. > > grep'd the source, but stricmp is only used for keywords and not actual > column data. > > Any help would be greatly appreciated. > > Thanks, > > Mark > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >