X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6FD9A9FA395 for ; Sat, 1 Jul 2006 11:01:20 -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 19196-10 for ; Sat, 1 Jul 2006 11:01:19 -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 1A4D99FA140 for ; Sat, 1 Jul 2006 11:01:20 -0300 (ADT) Received: from localhost (unknown [200.46.208.251]) by grzm.com (Postfix) with ESMTP id 1FF0E127D387 for ; Sat, 1 Jul 2006 15:01:14 +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 20729-09; Sat, 1 Jul 2006 11:01:13 -0300 (ADT) Received: from [172.16.1.101] (unknown [61.197.227.146]) by grzm.com (Postfix) with ESMTP id DA62F127C4ED; Sat, 1 Jul 2006 15:01:06 +0100 (BST) In-Reply-To: <0J1Q008ME8ZX7M90@VL-MO-MR003.ip.videotron.ca> References: <0J1Q008ME8ZX7M90@VL-MO-MR003.ip.videotron.ca> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <07BE168B-0F4D-417A-8EB4-E1D55F753E19@seespotcode.net> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Constraint UNIQUE on a column not case sensitive Date: Sat, 1 Jul 2006 23:01:08 +0900 To: Daniel CAUNE X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/5 X-Sequence-Number: 25579 On Jul 1, 2006, at 22:47 , Daniel CAUNE wrote: > The idea is to have an index on that column, in a not case > sensitive form, i.e. lower(MyColumn). I think you're really close. Try CREATE UNIQUE INDEX ci_mycolumn_idx ON mytable(lower(mycolumn)); Does that do what you're looking for? Michael Glaesemann grzm seespotcode net