Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: Case-insensitive select Date: Wed, 31 Aug 2011 23:00:28 +0000 (UTC) Organization: solani.org Lines: 13 Message-ID: References: <25ee8bf2-869c-427b-a4a4-5faf86f92d57@o26g2000vbi.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1314831628 20440 eJwFwYEBgDAIA7CXcNAi5zAs/59gAufDySAYWGx+3u4zhd4z0wo7uFJR8NegVqoGyAy7zR8vsBGV (31 Aug 2011 23:00:28 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Wed, 31 Aug 2011 23:00:28 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwVycsVgEAIA8CW5JOwKccH0n8J6mkOg6CxKwkmFut6xJ8OO6se2sAEdnDOODVpkZfub6v8BQyJEDw= Cancel-Lock: sha1:Fq9+xA/AVz4uXKItUl6nkf8qKH8= X-NNTP-Posting-Host: eJwNy8kBwCAMA7CVSFo7ZhzIsf8Irf7CQ2PGS/DFYBYvLGvdsIzVCKedmlb1eKm18vxBms24Hvns1NCUsuqAt4I7Ewe6dfwD464acA== Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:223 On Wed, 31 Aug 2011 20:42:40 +0100, Matthew Woodcraft wrote: > There's a case-insensitive string type in contrib (the "Additional > Supplied Modules"): There are unpleasant surprises with that, like the fact that unique index of that type is not case insensitive. Standard varchar data type, combined with a function index or a trigger should be more than adequate. -- http://mgogala.byethost5.com