Re: Disabling case sensitivity - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Disabling case sensitivity
Date
Msg-id 20020716092823.L50015-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Disabling case sensitivity  (linux_211@hotmail.com (igor))
List pgsql-general
On 15 Jul 2002, igor wrote:

> > 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".
> >
> In case-insensitive world yes.
>
>
> > 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.
> >
>
> Or wait until (if so) there will be possibility in POstgreSQL server
> to make smething like case-insensitive searches.

If you have a locale where those characters are considered the same,
presumably you'd get case-insensitive searches if the database was made in
that locale.  Barring that, you have source, you could go in and muck with
the appropriate functions.


pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: integer out of range errors
Next
From: Gregory Seidman
Date:
Subject: Re: brk() function and performance