啥也不说了,感谢楼主分享哇!
:D:D:D:D:D:D:D:D
with person_name as ( select c.id, array_to_string(array_agg(distinct p.c_name), ' , ') as p_name from biz_notification_config c join biz_notification_person p on p.id = any (string_to_array(c.persons, ',')::int[]) group by c.id ), group_name as ( select c.id, array_to_string(array_agg(distinct g.c_name), ' , ') as g_name from biz_notification_config c join biz_notification_group g on g.id = any (string_to_array(c.c_groups, ',')::int[]) group by c.id )select config.*, person_name.p_name, group_name.g_name from biz_notification_config config left join person_name on config.id = person_name.id left join group_name on config.id = group_name.id;
啥也不说了,感谢楼主分享哇!
啥也不说了,感谢楼主分享哇!
珍惜生命,果断回帖。
楼主你好你真厉害啊啊啊啊啊啊啊啊
啥也不说了,感谢楼主分享哇!
啥也不说了,感谢楼主分享哇!
来晚了,资源删了。。。