postgresql 增加字符串累加函数sumtext（转载)

CREATE OR REPLACE FUNCTION concat(character varying, character varying)
RETURNS character varying AS
$BODY$ 
DECLARE t varchar; 
BEGIN IF character_length($1) > 0 
THEN t = $1||','|| $2; 
ELSE  t = $2; 
END IF;
RETURN t;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION concat(character varying, character varying) OWNER TO postgres;
GRANT EXECUTE ON FUNCTION concat(character varying, character varying) TO public;
GRANT EXECUTE ON FUNCTION concat(character varying, character varying) TO postgres;

CREATE AGGREGATE sumtext(
BASETYPE=varchar,
SFUNC=concat,
STYPE=varchar);
ALTER AGGREGATE sumtext(varchar) OWNER TO postgres;

 

转载于:https://www.cnblogs.com/laiqiaojie/archive/2012/11/08/2760541.html