Re: Converting row elements into a arrays?

[Ron]

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.