From: | Ed Loehr <ELOEHR(at)austin(dot)rr(dot)com> |
---|---|
To: | Robert Hiltibidal <rob(at)y2k(dot)state(dot)il(dot)us> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] Data Search |
Date: | 1999-12-29 16:02:15 |
Message-ID: | 386A3087.4F04426D@austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jose Soares | 1999-12-31 10:22:25 | m$-access200 as PostgreSQL client |
Previous Message | Robert Hiltibidal | 1999-12-29 15:06:33 | Data Search |