Thread: Need help with simple update / insert trigger

Need help with simple update / insert trigger

From
Matthew Wilson
Date:
I have table sort of like this:

create table snoz (
    a bool default false,
    b bool default false,
    c bool default false
);

I want to set up a trigger so that any time a row is inserted or
updated, the value of c is set to true if a and/or b is true.

How can I do this?

Thanks!

Matt