Case Insensitive Queries - Mailing list pgsql-sql

From Mark
Subject Case Insensitive Queries
Date
Msg-id 200105291603.f4TG3BW08512@mail.ldssingles.com
Whole thread Raw
Responses Case Insensitive Queries  (Dan Lyke <danlyke@flutterby.com>)
Re: Case Insensitive Queries  (ANDREW PERRIN <aperrin@email.unc.edu>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: george young
Date:
Subject: Re: sql user management
Next
From: David Lizano
Date:
Subject: binary data