Re: Collation and Case Insensitivity

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Collation and Case Insensitivity
Date: 2011-01-15 00:41:02
Message-ID: igqqeu$o5v$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2011-01-14, Susanne Ebrecht <susanne(at)2ndQuadrant(dot)com> wrote:

> CREATE UNIQUE INDEX ON tab(LOWER(col));
> or even by using UPPER:
> CREATE UNIQUE INDEX ON tab(UPPER(col));

or possibly:

CREATE UNIQUE INDEX ON tab((col::citext));

--
⚂⚃ 100% natural

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Behringer Behringer 2011-01-15 02:32:14 join with 1 row limit
Previous Message Bruce Momjian 2011-01-14 22:33:31 Re: Upgrade path from 8.2.9 to 9.0