修改用户名称
CREATE OR REPLACE FUNCTION "public"."update_user_name"("uidinput" int8)
RETURNS "pg_catalog"."void" AS $BODY$ DECLARE
name VARCHAR ( 128 );
b RECORD;
BEGIN
FOR b IN ( SELECT A.uid, A.mobile FROM d_user A WHERE A.uid = uidinput )
loop
name := REPLACE ( uuid_generate_v4 ( ) :: TEXT, '-', '' )||b.mobile;
UPDATE d_user
SET user_name = name
WHERE
uid = b.uid ;
END loop;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100