On Wed, Jan 21, 2009 at 12:53 PM, Brent Wood wrote:
> I believe it is possible by using a table with nulls for the -1 values with a
> unique index on it as the foreign key, then a view which uses case or
> coalesce to present the nulls as -1, but this seems a cumbersome workaround.
This will w
Hi,
I have a table with a column of ID's (integer), these are unique except where
they = -1 (column 1)
I have a partial unique index where the value is not -1 to enforce this.
I want to use this column as a foreign key on a column in another table (column
2), but cannot without a full unique in
