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.