Re: case insensitive database ?

On Wed, 25 Apr 2001, Thorsten Mauch wrote:

> Is it possible to setup a database that is case insensitive ?
> is it also possible with a multbyte database ?

AFAIK, no, it's not possible to set up a case-insensitive database.
We're very into sensitivity in this community. :-)


Some possibilities:

the ILIKE operator does case insensitive searching,
as does the case insensitive regex operator (~*).


search using lower() or upper().
select * from pers where lower(fname) = 'joel';

(to speed these up, you can index pers on lower(fname)!)
"\h create index" for help


have two fields, fname and fname_lower, with a trigger to copy
lower(fname) to fname_lower on update.


Good luck!

HTH,
--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington