[GENERAL] array_agg-like thing over arrays

[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:

create table eg1 (class_id int, item_id int8, arrayofstuff text[]);

SELECT item_id, array_agg(arrayofstuff) 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
a...@crankycanuck.ca

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] array_agg-like thing over arrays

[Dmitriy Igrishin]

Hey Andrew,

2011/1/15 Andrew Sullivan a...@crankycanuck.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
 a...@crankycanuck.ca

 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general




-- 
// Dmitriy.

Re: [GENERAL] array_agg-like thing over arrays

[Andrew Sullivan]

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 make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general