From: | Joel Burton <jburton(at)scw(dot)org> |
---|---|
To: | Thorsten Mauch <mauch(at)imkenberg(dot)de> |
Cc: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: AW: case insensitive database ? |
Date: | 2001-04-24 23:03:19 |
Message-ID: | Pine.LNX.4.21.0104241901360.23237-100000@olympus.scw.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 25 Apr 2001, Thorsten Mauch wrote:
> Thanks for the answers.
> My prob is that i don't query the database
> directly. I use the CASTOR as a persitence-Framework.
> I create QOL-queries that are translated into
> SQL-Queries by the framework.
> So i can't use ILIKE or UPPER(expr) :(
> I also can't force the use of a special index.
> Howerver, i have to maintain a second field with upper
> letters, that i query instead of the orginal field
could you create a view and query that?
CREATE TABLE pers (fname);
INSERT INTO pers VALUES ('Joel');
CREATE VIEW pers_use_me AS SELECT fname, lower(fname) as lower_fname
FROM pers;
SELECT * FROM pers WHERE lower_fname = 'joel';
HTH,
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
From | Date | Subject | |
---|---|---|---|
Next Message | Thorsten Mauch | 2001-04-25 00:00:17 | AW: Re: AW: case insensitive database ? |
Previous Message | Thorsten Mauch | 2001-04-24 22:32:29 | AW: case insensitive database ? |