- 论坛徽章:
- 0
|
本帖最后由 lidexiang 于 2011-11-29 11:53 编辑
因为有个程序调用libpg c接口, 不支持transaction, 所以想个办法, 但是有两个问题:
1. execute 多条sql后, 能查询到这些sql影响到多少条记录吗?
以上有没有变量可以查询?
-----------------------------------------------------------------------------------------------------------------------------
CREATE OR REPLACE FUNCTION execsqls(sqls character varying)
RETURNS boolean AS
$BODY$
DECLARE
r BOOLEAN;
BEGIN
EXECUTE sqls;
-- TODO-1: I want to know how many records the input sqls effects?
RETURN TRUE;
EXCEPTION
WHEN others THEN
SELECT no_err_rollback() INTO r;
RAISE EXCEPTION '%:%', SQLSTATE, SQLERRM
END;
$BODY$
LANGUAGE plpgsql;
----------------------------------------------------------------------------------------------------------------------------- |
|