写存储过程

-- 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$

  LANGUAGE plpgsql VOLATILE

  执行函数（存储过程）
  SELECT hm_pro_product_limit();