Re: Disabling case sensitivity

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Disabling case sensitivity
Date: 2002-07-11 15:54:23
Message-ID: 20020711115423.D1170@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Wed, Jul 10, 2002 at 12:36:20PM -0700, igor wrote:

> the code. There must to be some way how to completely disable all
> case-sensitivity from the server without change the code, no?

I guess you could edit the sources, but I frankly cannot understand
the point of the request. If some system has decided that
'BoBsYouRUNcLE'='bobsyouruncle', then as far as I'm concerned, that
system is badly broken. They're not the same string. I should be
very annoyed not to be able to tell the difference.

Being able to ignore the difference strictly in terms of case
(appropriately defined by locale) is what things like ILIKE are for.
But "=" means "the same", not "sort of the same".

If your application can't be fixed, and relies entirely on some
(non-)feature of some other system, well, then, you have to use that
other system. Them's the breaks.

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-07-11 16:05:31 Re: FW: FW: Linking databases.
Previous Message Edgar Castanedo 2002-07-11 14:20:27 Re: redhat 7.3 problem

Browse pgsql-general by date

  From Date Subject
Next Message Linn Kubler 2002-07-11 16:09:50 syncronizing databases?
Previous Message Kaare Rasmussen 2002-07-11 15:51:00 Re: I am being interviewed by OReilly