Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 49A9E1337B5E for ; Thu, 13 Jan 2011 11:25:38 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 47131-02 for ; Thu, 13 Jan 2011 15:25:32 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.22]) by mail.postgresql.org (Postfix) with SMTP id 4CA641337B94 for ; Thu, 13 Jan 2011 11:25:30 -0400 (AST) Received: (qmail 19121 invoked by uid 0); 13 Jan 2011 15:25:29 -0000 Received: from 84.185.154.125 by www145.gmx.net with HTTP; Thu, 13 Jan 2011 16:25:28 +0100 (CET) Content-Type: text/plain; charset="utf-8" Date: Thu, 13 Jan 2011 16:25:28 +0100 From: "Karsten Hilbert" In-Reply-To: Message-ID: <20110113152528.218550@gmx.net> MIME-Version: 1.0 References: Subject: Re: Case Sensitivity To: pgsql-general@postgresql.org X-Authenticated: #1433807 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1/BG7VTZ37BN2R+JS29GzB5WTFiV/J4prnJnPkbxb 86dYXe/GD5jIxhSq0UpoYdK7JqL/9jiAOUYQ== Content-Transfer-Encoding: 8bit X-GMX-UID: O21KPTc0ZCEEQqGacGwhv+54IGhpZcY/ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201101/311 X-Sequence-Number: 171670 > you should to use a citext datatype > > http://www.postgresql.org/docs/9.0/interactive/citext.html Or: - use a functional index with lower() to ensure uniqueness - use a BEFORE trigger to lower() the inserted data Karsten -- GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt mit gratis Handy-Flat! http://portal.gmx.net/de/go/dsl