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?
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.m...@gmail.com:
Dear all,
Can I get the effected rows after executing sqls in function?
if you are doing insert, update or delete you can use retuirng command in the
query, work with a cursor to get the rows
- Mensaje original -
Dear all,
Can I get the effected rows after executing sqls in function?
e.g.:
CREATE OR REPLACE FUNCTION execsqls(sqls character