-- Function: hm_pro_product_limit()
-- DROP FUNCTION hm_pro_product_limit();
CREATE OR REPLACE FUNCTION hm_pro_product_limit(OUT out_status character varying)
RETURNS character varying AS
$BODY$
DECLARE
-- 声明常量并赋值
STR_ZERO CONSTANT CHARACTER VARYING(1) := '0';
STR_ONE CONSTANT CHARACTER VARYING(1) := '1';
BEGIN
--
update hm_product_limit_conf set todayremainmoney=limitmoney;
-- 正常结束
out_status := STR_ZERO;
EXCEPTION
WHEN OTHERS THEN
-- 异常结束
out_status := STR_ONE;
END;
$BODY$
-- DROP FUNCTION hm_pro_product_limit();
CREATE OR REPLACE FUNCTION hm_pro_product_limit(OUT out_status character varying)
RETURNS character varying AS
$BODY$
DECLARE
-- 声明常量并赋值
STR_ZERO CONSTANT CHARACTER VARYING(1) := '0';
STR_ONE CONSTANT CHARACTER VARYING(1) := '1';
BEGIN
--
update hm_product_limit_conf set todayremainmoney=limitmoney;
-- 正常结束
out_status := STR_ZERO;
EXCEPTION
WHEN OTHERS THEN
-- 异常结束
out_status := STR_ONE;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
执行函数(存储过程)
SELECT hm_pro_product_limit();