Re: Converting row elements into a arrays?

[Ray O'Donnell]

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
r...@rodonnell.ie