array_agg problem

From: "TJ O'Donnell" <tjo(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: array_agg problem
Date: 2011-08-19 21:22:53
Message-ID: CADqA_h-VU7v70vMKNQUxQ6-c+ZJhvuMgkDtNzAGTvWwjTMcqAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

array_agg says it can take any type of arg, but this seems not to work
when the arg in an integer array.

create temp table x(name text, val integer[]);
insert into x values('a',array[1,2,3]);
insert into x values('b',array[3,4,5]);
select * from x;
select max(val), min(val) from x;
select array_agg(val) from x;

Well, everything works except the last statement. In 8.4 I get
ERROR: could not find array type for data type integer[]

I was hoping for [1,2,3,4,5] or at least [1,2,3,3,4,5] or even [[1,2,3],[3,4,5]]
Am I not understanding something?

Thanks,
TJ O'Donnell

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-08-19 21:44:31 Re: array_agg problem
Previous Message Dimitri Fontaine 2011-08-19 21:20:38 Re: Dump a database excluding one table DATA?