Re: help converting trigger

2007-05-31 Thread Chris Hoover
Any help on how to do this in mysql On 5/30/07, Chris Hoover <[EMAIL PROTECTED]> wrote: I have the following trigger in Postgresql, how can we do this in Mysql? CREATE TRIGGER tr_encounter_lab_order_upd AFTER UPDATE ON encounter_lab_order FOR EACH ROW EXECUTE PROCEDURE tr_encou

help converting trigger

2007-05-30 Thread Chris Hoover
I have the following trigger in Postgresql, how can we do this in Mysql? CREATE TRIGGER tr_encounter_lab_order_upd AFTER UPDATE ON encounter_lab_order FOR EACH ROW EXECUTE PROCEDURE tr_encounter_lab_order_upd_trig_func(); CREATE OR REPLACE FUNCTION tr_encounter_lab_order_upd_trig_func()