I’d like to create an index that looks like this
create unique index myindex on mytable (column1, upper(column2));
In order to create the function expression, I have to check the “Generate Expression” box, which makes it impossible to choose the column without the expression.
Am I doing something wrong, or is this a bug? I know oracle can do this.