Subject | Re: [firebird-support] Compound Index |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2010-03-01T14:31:59Z |
01.03.2010 15:09, Stefan Heymann wrote:
to set case-insensitive collation on the column.
--
SY, SD.
> Is it possible to create a compound index where one of the columns isYou don't have to have index on UPPER to enforce uniqueness. Enough
> 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
to set case-insensitive collation on the column.
--
SY, SD.