Re: Use of !~* to keep a varchar column UNIQUE case-insensitive - Mailing list pgsql-novice

> You can define your index to be unique on a function of the column.  As an
> example:
>
> create table testtable (
>    name varchar(40) not NULL
> );
> create unique index my_case_insensitive_index on testtable(lower(name));

That'll work, thanks Sean!