PostgreSQL array_to_string array

select 
a.pub_id, 
a.group_name
from t_onlyou_wx_fans_label a where a.pub_id = '1BUSRGK7E0001AFCFEA90000BA352ED7';

 

select 
distinct
a.pub_id, 
array_to_string(array(SELECT b.group_name FROM  t_onlyou_wx_fans_label b  WHERE b.pub_id = a.pub_id), ',') as group_name
from t_onlyou_wx_fans_label a where a.pub_id = '1BUSRGK7E0001AFCFEA90000BA352ED7';

 

 

=============================

 

ORACLE： wm_concat

 

SELECT

other_colums,

wmsys.wm_concat (join_colum) as join_result

                FROM table_name

                             GROUP BY other_colums