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
pgsql-novice by date
|Next:||From: Joel Burton||Date: 2001-04-24 23:03:19|
|Subject: Re: AW: case insensitive database ?|
|Previous:||From: Poul L. Christiansen||Date: 2001-04-24 22:26:09|
|Subject: Re: case insensitive database ?|