Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group