Dear all, Can I get the effected rows after executing sqls in function? e.g.:
CREATE OR REPLACE FUNCTION execsqls(sqls character varying) RETURNS integer AS $BODY$ DECLARE BEGIN EXECUTE sqls; -- TODO-1: I want to know how many records the input sqls effects? RETURN effectedRows; END; $BODY$ LANGUAGE plpgsql; test: select execsqls('update mytable where name like ''%abc''') -- Regards, *Muiz*