From: "isaac flemmin" <isaac@knox.net>
To: <pgsql-sql@postgresql.org>
Subject: Case insensitive select
Date: Wed, 12 Jun 2002 17:43:39 -0700
Message-ID: <000001c21273$5cc3f3c0$ad463e04@ixic>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Importance: Normal

Hello,

I am using PostgreSQL 7.2 and I am trying to do a case insensitive
select statement using the lower function. I am using these lines from
the PostgreSQL 7.2 users guide as a template for my query.

--
"For example, a common way to do case-insensitive comparisons is to use
the lower function:
SELECT * FROM test1 WHERE lower(col1) = 'value';"
--

The query looks almost exactly the same but it always returns 0 results.
This does not make sense to me because if the query, 

"SELECT * FROM test1 WHERE col1 = 'Value';", 

returns something, then I assume the query, 

"SELECT * FROM test1 WHERE lower(col1) = 'value';", 

should return something as well. Do I not understand the way that the
lower function works, or is there something else I have to do? Obviously
I am doing something wrong or it would be working. I really have no idea
how to do a case insensitive query other than with the lower function.
If there is anyone out there who has any ideas on how to help me or can
point me toward something that will help me it would be very
appreciated.

Thanks
Isaac
--