-
unique constraint with conditioning?
Hi All:
Is there a way to create a unique constraint with 4 fields combined, such as colA, colB, colC, and colD.
but colD is for all the values but value = 3.
If this does not work out, trigger probably is the last way I would like to approach. and it is slower than constraint with many inserts.
thanks
David
-
Unique constraint will not work that way.
-
rmiao:
thanks the info. Have to go to trigger..
-D
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|