From: Josh Berkus <josh@agliodbs.com>
To: isaac flemmin <isaac@knox.net>
To: pgsql-sql@postgresql.org
Subject: Re: Case insensitive select
Date: Wed, 12 Jun 2002 18:08:19 -0700
Message-ID: <200206121808.19116.josh@agliodbs.com> (raw)
In-Reply-To: <000001c21273$5cc3f3c0$ad463e04@ixic>
References: <000001c21273$5cc3f3c0$ad463e04@ixic>
Issac,
> 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.
There is also:
SELECT * FROM test1 WHERE col1 ~* '^value';
or:
SELECT * FROM test1 WHERE col1 ILIKE 'value';
See Operators and Functions in the online docs.
--
-Josh Berkus
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: josh@agliodbs.com, isaac@knox.net
Subject: Re: Case insensitive select
In-Reply-To: <200206121808.19116.josh@agliodbs.com>
* 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