pgfunc

CREATE OR REPLACE FUNCTION public.fn_sys_log_add(

v_userid character varying,
v_username character varying,
v_logsimpledesc character varying,
v_logdetaildesc character varying,
v_cip character varying,
v_filelsh character varying)
RETURNS text AS
$BODY$
declare
v_count integer;
BEGIN
v_count :=0;
insert into t_sys_log(logid,logdt,createuserid,createusername,clientip,logsimpledesc,logdetaildesc,filelsh)
values(uuid_generatev4(),now(),v_userid,_username,v_cip,v_logdetaildesc,v_logdetaildesc,v_filelsh);
GET DIAGNOSTICS v_count = ROW_COUNT;
if (v_count>0) then
return 'success';
else return '';
end if;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION public.fn_sys_grantactiverec_add(character varying, text, text, character varying, character varying, character varying)
OWNER TO postgres;