‘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
版权声明：本文为trdsmile原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。