array_agg-like thing over arrays

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: array_agg-like thing over arrays
Date: 2011-01-14 22:21:58
Message-ID: 20110114222158.GT58308@shinkuro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
ajs(at)crankycanuck(dot)ca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-01-14 22:28:00 pg_db_role_setting info not dumped
Previous Message Alban Hertroys 2011-01-14 17:55:43 Re: Record with a field consisting of table rows