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));