t.kreienk...@la-z-boy.com
> -Original Message-
> From: Rob Nikander [mailto:rob.nikan...@gmail.com]
> Sent: Monday, November 12, 2018 10:30 AM
> To: Postgres General
> Cc: Scot Kreienkamp
> Subject: Re: help with aggregation query across a second text array column
> On Nov 12, 2018, at 9:40 AM, Scot Kreienkamp
> 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 t