Re: case insensitive unique index - Mailing list 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 :)
>
>