AW: Case Insensitive Queries - Mailing list pgsql-sql

From Manessinger Andreas
Subject AW: Case Insensitive Queries
Date
Msg-id 7864CE46A3ACD311848B005004EB51A5BB4335@msxadv1.host.magwien.gv.at
Whole thread Raw
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.

select * from account where lower(username) = 'test';

----Dipl.Ing. Andreas Manessinger  -  CCT / Competence Center TelematikMagistrat der Stadt Wien, Magistratsabteilung 14
-ADV,Rathausstr. 1, A-1082 WienE-Mail: man@adv.magwien.gv.at    Tel: (+43 1) 4000-91176       Fax: (+43 1)
4000-99-91176 WWW: http://service.wien.gv.at/ 
 


pgsql-sql by date:

Previous
From: "tjk@tksoft.com"
Date:
Subject: Re: Case Insensitive Queries
Next
From: Dan Lyke
Date:
Subject: Case Insensitive Queries