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> (raw)
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
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: isaac@knox.net
Subject: Re: Case insensitive select
In-Reply-To: <000001c21273$5cc3f3c0$ad463e04@ixic>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox