Re: Case insensitive collation - Mailing list pgsql-general

Marcel van Pinxteren, 18.01.2013 14:13:
> Desired behaviour:
> 1. If there is a row with 'ABC' (in a unique column) in the table, a row with 'abc' should not be allowed

That's an easy one:

create unique index on foo (lower(the_column));