Re: help with aggregation query across a second text array column

> On Nov 12, 2018, at 9:40 AM, Scot Kreienkamp <Scot(dot)Kreienkamp(at)la-z-boy(dot)com> wrote:
> …

I’m not too confident in my answer here (there could be a better way), but this might help. You could use the `unnest` function to transform the array into multiple rows. For example, given a table like

create table t1 (env text, cls text, cls2 text[]);

I can query it like:

select env, string_agg(cls, ‘,’)
from (select env, cls from t1
union
select env, unnest(cls2) from t1) t
group by env;

Rob