Quick Links

Case insensitive searchs

From:	Andy Lewis <alewis(at)themecca(dot)net>
To:	pgsql-sql(at)hub(dot)org
Subject:	Case insensitive searchs
Date:	1999-04-18 18:14:46
Message-ID:	Pine.LNX.4.05.9904181302020.21586-100000@tmg.themecca.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

I have a table that has city names in it. Some of the cities have a number
of different cases. For instance I may have:

San Antonio
san antonio
San antonio
SAN ANTONIO

My question is how can I do a distinct search for all cities and only get
one of each city?

Thanks in advance.

Re: [SQL] Case insensitive searchs at 1999-04-18 18:16:13 from Gregory W Burnham
Re: [SQL] Case insensitive searchs at 1999-04-18 18:44:39 from Ross J. Reedstrom
Re: [SQL] Case insensitive searchs at 1999-04-19 16:25:29 from D'Arcy J.M. Cain

	From	Date	Subject
Next Message	Gregory W Burnham	1999-04-18 18:16:13	Re: [SQL] Case insensitive searchs
Previous Message	Tom Lane	1999-04-18 17:51:32	Re: [SQL] Trouble with null text fields!