dean wrote:
> Hello all,
>
> A table T has 2 fields, one (L) holding letters 'Y' and 'N', and one
> (X) holding numbers. Is there a (non trigger) constraint such that for
> L='N' (and only this letter) the numbers must be unique? Records
> where L='Y' do not have to be unique.
>
> (I need to join another table to the L='N' group of records, and the
> join must be key-preserved).
>
> Cheers,
>
> Dean
>
Why not divide the table to two tables, one containing to constraint
(with UNIQUE) and the other not. Then make a view using UNION for the
original table.
--
Arto Viitanen, CSC Ltd,
Espoo, Finland
Received on Thu Feb 15 2007 - 00:41:39 CST
