Re: array_agg-like thing over arrays

Hey Andrew,

2011/1/15 Andrew Sullivan <ajs(at)crankycanuck(dot)ca>

> 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, arrayofstuff text[]);
>
> SELECT item_id, array_agg(arrayofstuff) from eg1 WHERE class_id = 1;
>
Try SELECT item_id, array_agg(arrayofstuff::text) from eg1 WHERE class_id =
1;

>
> But this, of course, gives an ERROR: could not find array type for data
> type text[].
>
> What am I missing, or have I just misremembered that this was ever
> possible?
>
> Thanks,
>
> A
>
> --
> Andrew Sullivan
> ajs(at)crankycanuck(dot)ca
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
// Dmitriy.