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