From: | "Eugene Selkov Jr(dot)" <selkovjr(at)mcs(dot)anl(dot)gov> |
---|---|
To: | Jerome Knobl <jknobl(at)mandanet(dot)ch> |
Cc: | Mike Lemler <coronach(at)datacruz(dot)com>, pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Case in-sensitive searches |
Date: | 1998-05-20 15:47:10 |
Message-ID: | 3562FAFE.185F242D@mcs.anl.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Jerome Knobl wrote:
>
> Hi,
>
> I found an inellegant sollution. You can put every character in uppercase
> like that :
>
> Select * From table_membres where upper(nom) like upper('myname');
>
I use a much less elegant solution that works extremely well for me. I
add a copy of the column to the table and fold it uppercase before I
load the table. I also do some additional processing in it, in order to
eliminate things that may interfere with indexing, such as accents in
European characters. The application then decides whether to search in
the original or in the processed copy of the column, but the original
data are always returned to the user.
--Gene
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-05-21 02:03:18 | list of tables? |
Previous Message | The Hermit Hacker | 1998-05-20 00:06:08 | Re: [SQL] Exhausted memory |