On Jul 1, 2006, at 22:47 , Daniel CAUNE wrote:
> The idea is to have an index on that column, in a not case
> sensitive form, i.e. lower(MyColumn).
I think you're really close. Try
CREATE UNIQUE INDEX ci_mycolumn_idx ON mytable(lower(mycolumn));
Does that do what you're looking for?
Michael Glaesemann
grzm seespotcode net