From: Tom Lane <tgl@sss.pgh.pa.us>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Richard Huxton <dev@archonet.com>
Cc: Dario Ottaviano <dario_ottaviano@togliquestovirgilio.it>
Cc: pgsql-general@postgresql.org
Subject: Re: Case sensitivity
Date: Mon, 12 Jan 2004 17:27:13 -0500
Message-ID: <5506.1073946433@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.33.0401121057560.19667-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0401121057560.19667-100000@css120.ihs.com>
"scott.marlowe" <scott.marlowe@ihs.com> writes:
> Is there a case insensitive locale? Or is that even possible?
It's certainly possible, but I don't know of any standard locales that
behave like that.
One could also imagine developing a new set of comparison operators that
do case-insensitive comparison, and then making a special index opclass
for that. The locale-insensitive operators Peter built to optimize LIKE
indexing in 7.4 would be a good model.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: tgl@sss.pgh.pa.us, scott.marlowe@ihs.com, dev@archonet.com, dario_ottaviano@togliquestovirgilio.it
Subject: Re: Case sensitivity
In-Reply-To: <5506.1073946433@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox