Daniel CAUNE <d(dot)caune(at)free(dot)fr> writes:
> Hi,
>
> I would like to find an efficient solution for adding/implementing a
> constraint UNIQUE on a VARCHAR column not case sensitive:
>
> ALTER TABLE MyTable
> ADD CONSTRAINT UNQ_MyTable_MyColumn
> UNIQUE (lower(MyColumn)); -- invalid syntax
>
> The idea is to have an index on that column, in a not case sensitive form,
> i.e. lower(MyColumn).
What's the problem with CREATE INDEX then?
CREATE INDEX idx_something ON mytable (lower(mycolumn));
--
Jorge Godoy <jgodoy(at)gmail(dot)com>