X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1D3F09FA3AF for ; Wed, 21 Jun 2006 23:24:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 47529-04 for ; Wed, 21 Jun 2006 23:24:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from grzm.com (grzm.com [200.46.204.98]) by postgresql.org (Postfix) with ESMTP id C074E9FA322 for ; Wed, 21 Jun 2006 23:24:31 -0300 (ADT) Received: from localhost (unknown [200.46.208.251]) by grzm.com (Postfix) with ESMTP id 6A201127D326 for ; Thu, 22 Jun 2006 03:24:25 +0100 (BST) Received: from grzm.com ([200.46.204.98]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 61587-03; Wed, 21 Jun 2006 23:24:26 -0300 (ADT) Received: from [172.16.1.204] (unknown [61.197.227.146]) by grzm.com (Postfix) with ESMTP id 31931127C4FA; Thu, 22 Jun 2006 03:24:19 +0100 (BST) Mime-Version: 1.0 (Apple Message framework v750) In-Reply-To: <200606211819.08239.josh@agliodbs.com> References: <54D833BE-A58F-47B8-B070-2AEDC0802468@kineticode.com> <200606211819.08239.josh@agliodbs.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-performance@postgresql.org, David Wheeler Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Performance of DOMAINs Date: Thu, 22 Jun 2006 11:24:22 +0900 X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/429 X-Sequence-Number: 19786 > since I'd like to have/create a truly case-insensitive > text type (ITEXT anyone?). I haven't seen it mentioned in this thread yet, but have you looked at citext? http://gborg.postgresql.org/project/citext/projdisplay.php I don't have any experience with it, but perhaps it can do what you're looking for. Michael Glaesemann grzm seespotcode net