Received: from Mail.austin.rr.com (sm2.texas.rr.com [24.93.35.55])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA98973
	for <pgsql-interfaces@postgresql.org>;
	Wed, 29 Dec 1999 11:01:03 -0500 (EST)
	(envelope-from ELOEHR@austin.rr.com)
Received: from austin.rr.com ([24.28.74.113]) by Mail.austin.rr.com with
	Microsoft SMTPSVC(5.5.1877.197.19); Wed, 29 Dec 1999 09:52:20 -0600
Sender: ed
Message-ID: <386A3087.4F04426D@austin.rr.com>
Date: Wed, 29 Dec 1999 10:02:15 -0600
From: Ed Loehr <ELOEHR@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Robert Hiltibidal <rob@y2k.state.il.us>
CC: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Data Search
References: <3.0.6.32.19991229090633.0097a4a0@y2k.state.il.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> Both databases have a mixture of upper and lowercase characters. Is there a
> way to tell postgres to consider a match if the absolute character is the
> same regardless of case?
>
> Ex
> 'ROB' should also produce a hit if postgres encouters 'rob'
>

http://www.postgresql.org/docs/postgres/functions2470.htm

db=> create table t(s varchar);
CREATE
db=> insert into t values ('Joe');
INSERT 365513 1
db=> insert into t values ('JoE');
INSERT 365514 1
db=> insert into t values ('JOE');
INSERT 365515 1
db=> select * from t where s like 'joe';
s
-
(0 rows)

db=> select * from t where lower(s) like 'joe';
s
---
Joe
JoE
JOE
(3 rows)

Cheers,
Ed Loehr