Re: case insensitive unique index

From: Michael Fork <mfork(at)toledolink(dot)com>
To: Culley Harrelson <culleyharrelson(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: case insensitive unique index
Date: 2001-01-30 22:18:06
Message-ID: Pine.BSI.4.21.0101301715500.14806-100000@glass.toledolink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can create a case insensitive, unique index like this:

CREATE UNIQUE INDEX indexname ON tablename (lower(fieldname))

Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio

On Tue, 30 Jan 2001, Culley Harrelson wrote:

> is there a way to make a unique index case insesitive
> for text data? I can change case in my front end code but I
> thought I'd ask :)
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2001-01-30 23:31:36 Re: design
Previous Message Culley Harrelson 2001-01-30 21:36:31 case insensitive unique index