Results 1 to 3 of 3

Thread: unique constraint with conditioning?

  1. #1
    Join Date
    Mar 2003
    Posts
    383

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Unique constraint will not work that way.

  3. #3
    Join Date
    Mar 2003
    Posts
    383
    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
  •