--pgsql中的参数只能在方法中定义,在方法外面定义就会报错
CREATE OR REPLACE FUNCTION getrole()
RETURNS SETOF record AS
$BODY$
DECLARE
i int;
starttime timestamp;
endtime timestamp;
strSQL varchar(4000);
rec record;
BEGIN
strSQL:='SELECT * FROM sys_Roles';
EXECUTE strSQL;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
ROWS 1000;
ALTER FUNCTION getrole()
OWNER TO hfzc;
CREATE OR REPLACE FUNCTION getrole()
RETURNS SETOF record AS
$BODY$
DECLARE
i int;
starttime timestamp;
endtime timestamp;
strSQL varchar(4000);
rec record;
BEGIN
strSQL:='SELECT * FROM sys_Roles';
EXECUTE strSQL;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
ROWS 1000;
ALTER FUNCTION getrole()
OWNER TO hfzc;