Re: [GENERAL] Trigger does not behave as expected

Goboxe wrote: Hi, I have a trigger as below. I am wondering why when I tried to insert to master table with date= 20080908, the trigger does not insert to z_agg_tmcarr_pfx_gtwy_cc_w_20080908. First, check using \d tablename to make sure that the trigger is actually defined on the table. Coul

[GENERAL] Trigger does not behave as expected

Hi, I have a trigger as below. I am wondering why when I tried to insert to master table with date= 20080908, the trigger does not insert to z_agg_tmcarr_pfx_gtwy_cc_w_20080908. Is that something wrong with the statement "ELSEIF NEW.CallDate >= 20080908 AND NEW.CallDate <= 20080914 THEN"? ---