On April 26, 2006 02:35 pm, "Bert" <[EMAIL PROTECTED]> wrote: > CREATE TRIGGER trigger_sum > AFTER INSERT OR UPDATE > ON test > FOR EACH ROW > EXECUTE PROCEDURE trigger_test(); > > The inserting and updating is doing well, but its not summing up the a > and b and save it to the c column. So far maybe you can help me second > time.
That would need to run BEFORE INSERT OR UPDATE, not AFTER. -- Alan ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
