Toad World® Forums

creating an index with multiple columns where one has a function


#1

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.


#2

Hi,

you can either choose columns or specify full code manually. Currently you cannot combine both. In your case, check the Generate Expression checkbox and specify the full code in the Expression field: column1, upper(column2)

If you want to see SQL, click tab SQL Preview on form Entity Properties.

Regards,

Vaclav