2011/1/15 Andrew Sullivan <ajs@xxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
// Dmitriy.
