Re: Converting row elements into a arrays?

["Ray O'Donnell" <ray@xxxxxxxxxxxx>]

On 02/03/2023 21: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;

  ... from foo ...

R.


--
Raymond O'Donnell // Galway // Ireland
ray@xxxxxxxxxxxx