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
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 |
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 |