AW: case insensitive database ?

From: Thorsten Mauch <mauch(at)imkenberg(dot)de>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: AW: case insensitive database ?
Date: 2001-04-24 22:32:29
Message-ID: E5A63F34D141D111A6F4080009D70ACA0A389F@imkedv_pdc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Thorsten

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2001-04-24 23:03:19 Re: AW: case insensitive database ?
Previous Message Poul L. Christiansen 2001-04-24 22:26:09 Re: case insensitive database ?