--- Helen Borrie <helebor@d...> wrote:

> >Can a trigger be defined to "trigger" at different events. I mean

is there a

> >way to make the following work:
> >create trigger my_trigger for my_table
> >before insert or update as
> > begin
> >
> > end
>
> No. You need to define each trigger separately.
>

Hi all. But you can create stored procedure performs actions
identical for different triggers and call it from your triggers
passing needed New. and Old. values as parameters. Not very
comfortable having many those parameters but save time and improve
reliabilty when those actions should be changed.

Best regards.