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

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

pgsql-novice by date

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

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