Hi, I have bunch of rules created for tables to implement upsert functionality. My problem is our tables gets updated from multiple places , non –necessarily with the same no of columns. I want to figure out columns are being asked to be updated E.g. The rule for the the table base-table is CREATE OR REPLACE RULE base-table-rule AS ON INSERT TO base-table WHERE (EXISTS ( SELECT 1 FROM base-table WHERE bas-table::x1 = new.x1 )) DO INSTEAD UPDATE base-table SET x1=new.x1,x2=new.x2,x3 =new.x3,x4=new.x4 WHERE base-table.x1= new.x1; 1) user 1 comes with the below insert Insert into base-table(x1,x2,x3,x4) values(v1,v2,v3,v4); 2) user 2 comes with the below insert Insert into base-table(x1,x2) values(v1,v2); Since user 2 uses only x1 and x2 as its column the rule replaces x3 and x4 with null. Is there a way to figure out that only x1 and x2 is being asked for an updating. In the above example column x1 is the primary key. Thanks, Sajeev |
