Hello yes, you can. Look on GET DIAGNOSTICS statement http://www.postgresql.org/docs/9.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS Regards Pavel Stehule 2011/11/29 Muiz <work.muiz@xxxxxxxxx>: > 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 > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
