Re: Trigger

From: Spencer <spencerp_at_swbell.net>
Date: Fri, 29 Jun 2001 22:00:01 -0500
Message-ID: <Lgb%6.119$uk1.7759@nnrp1.sbc.net>

if my_col3 is always equal to the expression (my_col1+my_col2), i would suggest that perhaps the column is redundant, and is not actually needed... just use the expression (my_col1+my_col2)

"kpdp" <kpdp_at_nowhere.com> wrote in message news:3B3CC83E.BC7C1774_at_nowhere.com...
> "Daniel A. Morgan" wrote:
>
> > :NEW.my_col3 := :NEW.my_col1 + :NEW.my_col2;
> >
> > A trigger is no place for an update statement on the host table.
> >
> > Daniel A. Morgan
>
> You'are right ! It works ! Thanks a lot :o)
>
Received on Fri Jun 29 2001 - 22:00:01 CDT