Re: Check constraint violated

On Sat, 14 Jun 2003 13:38:25 +0200, Sybrand Bakker wrote:

>On Sat, 14 Jun 2003 12:50:48 +0530, Me <somebudy_at_despammed.com> wrote:
>
>>On Fri, 13 Jun 2003 21:33:43 +0530, Me wrote:
>>>2) How can I put a check constraint that allows entering data into apointee only
>>>if the nominee's age is lesser than 18?
>>
>>Could someone help me with this constraint.
>>
>>Thanks.
>
>
>Trying to avoid to read the manual are we?

There was a time when the UNIX man pages were like a horror movie for me, and now there is a time when I can't help seeing the man pages for every small problem I have. In the beginning no one can understand the manuals.

Now lets see if someone can learn sed,awk or perl commands by using the manual.

Try
man find
man perl

>decode(sign(<age_column> - 18), 1, false, 0, false, true)
Frankly I am not able to make out what this is, but I don't think it can solve the problem as what ever you do must involve 2 relations and 2 columns.

Thanks. Received on Sat Jun 14 2003 - 07:51:30 CDT