[GENERAL] What is the difference between rule and triggers

Hi Everybody, What is the difference between creating a rule and a trigger? Regards skarthi _ i'm making a difference. Make every IM count for the cause of your choice. Join Now. http://clk.atdmt.com/MSN/go/msnnkwme00800

Re: [GENERAL] [ADMIN] How to get the DML Commands exceuted from functions

CREATE OR REPLACE FUNCTION xyz() returns int4 as $body$ DECLARE BEGIN IF (TG_OP = 'DELETE') THEN n_id = OLD.campaign_id; EXECUTE 'DELETE FROM cn_mapping WHERE campaign_id = '||quote_literal(n_id); RETURN 0; END IF; END; $body$ LANGUAGE 'plpgsql' VOLATILE;