Skip site navigation (1) Skip section navigation (2)

Re: AW: case insensitive database ?

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 (view raw or flat)
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


In response to

pgsql-novice by date

Next:From: Thorsten MauchDate: 2001-04-25 00:00:17
Subject: AW: Re: AW: case insensitive database ?
Previous:From: Thorsten MauchDate: 2001-04-24 22:32:29
Subject: AW: case insensitive database ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group