On Sat, Jan 15, 2011 at 01:35:20AM +0300, Dmitriy Igrishin wrote:
> Try SELECT item_id, array_agg(arrayofstuff::text) from eg1 WHERE class_id =
> 1;
Doh! That's it. Thanks!
A
--
Andrew Sullivan
a...@crankycanuck.ca
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
Hey Andrew,
2011/1/15 Andrew Sullivan
> Hi all,
>
> I could swear I remember being able to do this in the past, but it
> doesn't seem I can remember how, and I have been unable to find
> anything in The Fine Materials.
>
> I want to produce the output of rows of arrays as an aggregated array:
>
Hi all,
I could swear I remember being able to do this in the past, but it
doesn't seem I can remember how, and I have been unable to find
anything in The Fine Materials.
I want to produce the output of rows of arrays as an aggregated array:
create table eg1 (class_id int, item_id int8, arrayofs
