pgsql 数组格式的查询

查询各连锁的标签 

select a.id,a.name,b.name as label from client as a
left join label b
on b.id = any(a.label) 
where a.category='6' and b.parentid=1

如果有多个标签，可以用array_add()

select a.id,a.name,array_agg(b.name) as label from client as a
left join label b
on b.id = any(a.label) 
where a.category='6' 
group by a.id,a.name

select a.id,a.name,array_agg(b.name) as label from client as a
left join label b
on b.id = any(a.label) 
where a.category='6' and label is not null
group by a.id,a.name