X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 82D8452ADC for ; Tue, 9 Aug 2005 12:54:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84231-03 for ; Tue, 9 Aug 2005 15:54:19 +0000 (GMT) Received: from svana.org (svana.org [203.20.62.76]) by svr1.postgresql.org (Postfix) with ESMTP id B8A91529E7 for ; Tue, 9 Aug 2005 12:54:10 -0300 (ADT) Received: from kleptog by svana.org with local (Exim 3.35 #1 (Debian)) id 1E2WQU-00042B-00; Wed, 10 Aug 2005 01:54:02 +1000 Date: Tue, 9 Aug 2005 17:54:02 +0200 From: Martijn van Oosterhout To: Tom Lane Cc: Frank Millman , pgsql-general@postgresql.org Subject: Re: Case sensitivity Message-ID: <20050809155402.GE8244@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: Tom Lane , Frank Millman , pgsql-general@postgresql.org References: <42F72C06.8000000@archonet.com> <20050809095743.GB8244@svana.org> <16183.1123599767@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="uxuisgdDHaNETlh8" Content-Disposition: inline In-Reply-To: <16183.1123599767@sss.pgh.pa.us> User-Agent: Mutt/1.3.28i X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: X-Warning: Normally my messages are signed, but not on the ozTiVo list due to legacy application support X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/454 X-Sequence-Number: 81862 --uxuisgdDHaNETlh8 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Aug 09, 2005 at 11:02:47AM -0400, Tom Lane wrote: > Martijn van Oosterhout writes: > > Another option would be to create a new datatype 'itext' which works > > like text except it compares case insensetively. PostgreSQL is flexible > > like that. Here's something to get you started, see below for example. >=20 > > http://svana.org/kleptog/pgsql/type_itext.sql >=20 > > At the moment it uses SQL functions for the comparisons, for production > > you'd probably want to have them in C for performance. >=20 > I believe there is a C-coded type like this on gborg ("citext" is the > name I think). And so it is, full points to Tom. Here's the link: http://gborg.postgresql.org/project/citext/projdisplay.php I couldn't work out any obvious way to make google spit out this link without the magic word "citext", so hopefully this reference will raise the score enough that a plain google search for "case insensitive postgresql" will find it. Have a nice day, --=20 Martijn van Oosterhout http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them. --uxuisgdDHaNETlh8 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQFC+NGZIB7bNG8LQkwRAmREAJ0Wmi9jFDSkF5gdqPC8F/xHtu4OVACfTU4d juGowQXJzovrfihAO0dR6KY= =ZIEr -----END PGP SIGNATURE----- --uxuisgdDHaNETlh8--