不常用的sql记录

‘1,2,3’ 是where in的主键

 select au_idx, au_user_name, (
		SELECT string_agg(arl_value, ',') from admin_role_list where arl_idx::text = ANY(string_to_array(au_roles, ','))
 ) as roles from admin_user where au_idx = 3