Re: newbie question on triggers
From: Ed Bruce <edward_at_igate1.hac.com>
Date: 1995/10/13
Message-ID: <edward-1310950817590001_at_r-618macip18.hac.com>#1/1
Date: 1995/10/13
Message-ID: <edward-1310950817590001_at_r-618macip18.hac.com>#1/1
In article <1995Oct11.165501_at_seuss.cc.utexas.edu>, godzilla_at_seuss.cc.utexas.edu (Jim Lyons) wrote:
>
> Is there any way I can do this?
Allow the column to have null values and then use your trigger to enforce the not null constraint. But I think the solution of using a CHECK constraint and well chosen constraint name to be a better solution.
-- Ed Bruce edward_at_igate1.hac.com Key fingerprint = 62 8D FC 8F 27 2F 89 D0 8B 38 7E 34 33 74 C2 36Received on Fri Oct 13 1995 - 00:00:00 CET