I have a varchar as the primary key of one of my tables. What I would like to do is add a constraint so that case does not matter when comparing the text values. For example, if I have "text" in the primary key column of one of my rows, I want to dissallow the ability to insert a row with "Text" in the primary key column.
This is what I have tried so far:
constraint blah check (column_name not in (select lower(column_name) from table_name));
constraint blah unique(lower(column_name));
Neither worked of course (sorry if those ideas seem off the wall, I'm used to Oracle's syntax, not that they would work in Oracle).