Re: Check constraint violated

Originally posted by Me
> On Sat, 14 Jun 2003 13:09:53 +0000, andrewst wrote:
>
> >Originally posted by andrewst
> >> ALTER TABLE appointee
> >> ADD CONSTRAINT chk_nominee_age CHECK (age Of course, Age is a
> rather silly column to hold in a table, because it
> >is meaningless by itself. Without knowing the date when the Age
> value
> >was entered/updated, it tells you only the the person is "at
> least" 17
> >(e.g.); by now he.she could be 18, 19, 42, ... What you should
> really
> >hold is date of birth (or year of birth or whatever suits your
> needs).
>
> But the date on which the proposal was submitted has been stored in
> PROP_POLICY_DATA->PROP_DATE
>
> Moreover it is the age of the proposer at the time submitting the
> proposal that
> is crucial. Then the policy may be alloted for a period of 5 or 10
> years during
> which the actual age of the proposer is immeterial.
>

In that case fair enough perhaps.

Originally posted by Me
> I had sent you a mail but it bounced back.
> Please answer this post by mail rather than answering it in the group
> if it's ok
> with you.
> Thanks.

I have not answered by email. Apart from any other reasons, I don't know your email address.

--
Posted via http://dbforums.com