Re: [SQL] case-insensitive lookups... - Mailing list pgsql-sql

From Marc Howard Zuckman
Subject Re: [SQL] case-insensitive lookups...
Date
Msg-id Pine.LNX.4.00.9807131954180.1933-100000@fallon.classyad.com
Whole thread Raw
In response to case-insensitive lookups...  (Lorenzo Huerta <lorenzo@nmsu.edu>)
List pgsql-sql
On Mon, 13 Jul 1998, Lorenzo Huerta wrote:

>
> is there a way to do selects /etc on fields without regard to upper/lower
> case of the data in the fields?

select * from tablename where attribute ~* 'stringvalue' ;
                                        ^^ the case insensitive regex
                                           equality operator.

Marc Zuckman
marc@fallon.classyad.com

_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
_     Visit The Home and Condo MarketPlace              _
_          http://www.ClassyAd.com                  _
_                                  _
_  FREE basic property listings/advertisements and searches.  _
_                                  _
_  Try our premium, yet inexpensive services for a real          _
_   selling or buying edge!                      _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_


pgsql-sql by date:

Previous
From: Lorenzo Huerta
Date:
Subject: case-insensitive lookups...
Next
From: The Web Administrator
Date:
Subject: SubQueries