Postgres Pro
Downloads
Home   >   mailing lists

Re: Collation and Case Insensitivity - Mailing list pgsql-novice

From Jasen Betts
Subject Re: Collation and Case Insensitivity
Date
Msg-id igqqeu$o5v$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Collation and Case Insensitivity  ("Phillip Smith" <phillip@softworks.com>)
List pgsql-novice
Tree view 
On 2011-01-14, Susanne Ebrecht <susanne@2ndQuadrant.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

pgsql-novice by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Upgrade path from 8.2.9 to 9.0
Next
From: Behringer Behringer
Date:
Subject: join with 1 row limit