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

[Rob Nikander]

> On Nov 12, 2018, at 9:40 AM, Scot Kreienkamp <scot.kreienk...@la-z-boy.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