Subject Re: [firebird-support] Compound Index
Author Dimitry Sibiryakov
01.03.2010 15:09, Stefan Heymann wrote:
> 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.
--
SY, SD.