sisem 发表于 2020-12-23 02:13:14
啥也不说了,感谢楼主分享哇!nicky666 发表于 2020-12-29 03:28:46
:D:D:D:D:D:D:D:Dhlmzr 发表于 2020-12-31 22:04:35
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;biaowehyz 发表于 2021-1-14 14:32:41
啥也不说了,感谢楼主分享哇!lif_119 发表于 2021-1-18 23:31:45
啥也不说了,感谢楼主分享哇!xiaoliumang001 发表于 2021-1-19 16:06:35
珍惜生命,果断回帖。674640344 发表于 2021-1-19 22:38:51
楼主你好你真厉害啊啊啊啊啊啊啊啊mceddie 发表于 2021-1-20 17:12:25
啥也不说了,感谢楼主分享哇!minpei23 发表于 2021-1-27 23:14:18
啥也不说了,感谢楼主分享哇!minpei23 发表于 2021-1-27 23:15:26
来晚了,资源删了。。。