It is in the list archives several times. All you need is to use some basic SQL. select * from mytable where upper('my criteria') = upper(mytable.info); Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "David Reid" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 9:58 AM Subject: [GENERAL] Case insensitive selects? > Does pgsql support this and how would I do it? > > david
- Re: [GENERAL] Case insensitive selects? Adam Lang
- Re: [GENERAL] Case insensitive selects? Anand Raman
- Re: [GENERAL] Case insensitive selects? Michael Fork
- Re: [GENERAL] Case insensitive selects... David Wheeler
- [GENERAL] Re: Case insensitive sel... Mitch Vincent
- Re: [GENERAL] Case insensitive sel... Bruce Momjian
- Re: [GENERAL] Case insensitive selects? David Wheeler
- Re: [GENERAL] Case insensitive selects? David Wheeler
- Re: [GENERAL] Case insensitive selects? David Wheeler
- Re: [GENERAL] Case insensitive selects? Bruce Momjian
- Re: [GENERAL] Case insensitive selects? Martijn van Oosterhout