Thread: ON DELETE RULE problem

ON DELETE RULE problem

From
"Nagib Abi Fadel"
Date:
Hi,
 
I need to run the following  delete command on a view table1_v :
"
delete from table1_v where table1_var1=$table1_var1 and table1_var2 not in (select  t2.id from table2_v t2,table3_v t3   
where t3.vers_id=t2.vers_id and t3.var3=$var3);
"
I have not been able to figure out how to create the corresponding rule.
 
can anyone help.
 
thx.