Re: Converting row elements into a arrays?

[Ron <ronljohnsonjr@xxxxxxxxx>]

On 3/2/23 15:01, Ray O'Donnell wrote:
> On 02/03/2023 20:58, Ron wrote:
> > Postgresql 12.13
> >
> > Given the sample below, I'm looking for how to generate this output.  
> > It's like GROUP BY, but generating an array instead of an aggreate number.
> >   f1 | f2_array
> > ----+---------
> > 1 | {1,2,3}
> >    2 | {1,2,3,4}
> >    3 | {1,2}
>
> Something like this (off the top of my head)? -
>
>    select f1, array_agg(f2) as f2_array group by f1;
>
> Hope that helps (and that it's right!).

That did it.

--
Born in Arizona, moved to Babylonia.