Re: Conditional Constraint?

From: Kenneth Koenraadt <plovmand_at_mail-online.dk>
Date: 24 Dec 2002 02:02:15 -0800
Message-ID: <25fb645f.0212240202.32845f94@posting.google.com>

Your wish has been granted, Doc Morgan :

ALTER TABLE Demerit ADD CONSTRAINT a2 CHECK (dem_code <= 20 or dem_code > 20 and points <=3);

to repeat myself.....

Now, Mr. "teacher": how about *reading* people's postings before answering them.....

Kenneth Koenraadt

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E078F1E.8281DA32_at_exesolutions.com>...
> J Alex wrote:
>
> >
> I missed Jonathan's posting but the request was for:
>
> "All DEM_CODE should carry an integer POINT"
>
> I'd like to see a Check Constraint with an "AND" clause.
>
> Daniel Morgan
Received on Tue Dec 24 2002 - 04:02:15 CST