Subject Re: [firebird-support] Compound Index
Author Stefan Heymann
>> Is it possible to create a compound index where one of the columns is
>> a COMPUTED BY expression? (I need to create a unique compound index of
>> the UPPER() of a varchar field and an integer field).
>> Firebird 2.1.3

> You don't have to have index on UPPER to enforce uniqueness. Enough
> to set case-insensitive collation on the column.

There is no case-insensitive collation for my character set and
language (ISO8859_1, DE_DE).

Besides that, I want to enforce uniqueness on the *combination* of two
fields (a VARCHAR(50) field and an INTEGER field where the VARCHAR
field has to be UPPERed).

I think will write an old-school trigger that does the UPPERing ...