On Jan 25, 2009, at 3:07 AM, Jasen Betts wrote:
>> I want to use this column as a foreign key on a column in another
>> table
>> (column 2), but cannot without a full unique index.
>
> a full unique index is easy use an expression that's null for -1.
>
> create unique index foobar on foo( ( case fee when -1 then null else
> fee end ) );
anything wrong with create unique index foobar on foo where fee <> -1 ?
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,497f50e9747031810420427!