X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A59B6D1B47A for ; Mon, 12 Jan 2004 22:27:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81560-07 for ; Mon, 12 Jan 2004 18:27:28 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 79553D1B440 for ; Mon, 12 Jan 2004 18:27:25 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0CMRD19005507; Mon, 12 Jan 2004 17:27:13 -0500 (EST) To: "scott.marlowe" Cc: Richard Huxton , Dario Ottaviano , pgsql-general@postgresql.org Subject: Re: Case sensitivity In-reply-to: References: Comments: In-reply-to "scott.marlowe" message dated "Mon, 12 Jan 2004 10:58:22 -0700" Date: Mon, 12 Jan 2004 17:27:13 -0500 Message-ID: <5506.1073946433@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/537 X-Sequence-Number: 55565 "scott.marlowe" 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