Re: How to say one of a group of columns is required?

From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 2000/05/21
Message-ID: <8gaojc$in7@grant.grant.UUCP>#1/1

>
> It looks like I need the trigger!
>
> Andy

Why don't You use a constraint

CHECK(my_key IS NOT NULL OR my_lookup1 IS NOT NULL OR ...)?

> >> I have a table with three columns - one or more of which is required.
> >> MY_KEY
> >> MY_LOOKUP1
> >> MY_LOOKUP2
> >> MY_LOOKUP3
> >>
> >> where at least one of the MY_LOOKUPs is required.
> >>
> >> Is there a check constraint for this?

---

Alexander I. Doroshko, Bank "Grant", Kharkov, Ukraine aid_at_grant.kharkov.ua Received on Sun May 21 2000 - 00:00:00 CDT