[postgresql] for循环创建函数_自写pgsql函数 for循环

修改用户名称

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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19