I'm trying to aggregate a list of table attributes into an array.
The actual code looks something like this:
node_ref AS id,
array_agg(DISTINCT ARRAY[namespace, name, value]) as annotations
GROUP BY id;
I guess the minimal example that reproduces the error is:
annis=> select array_agg(array['a'::varchar, 'b', 'c']);
ERROR: could not find array type for data type character varying
Why doesn't this work?
pgsql-general by date
|Next:||From: JC Praud||Date: 2009-10-28 15:21:11|
|Subject: Re: auto truncate/vacuum full|
|Previous:||From: Peter Hunsberger||Date: 2009-10-28 15:12:19|
|Subject: Re: still on joining array/inline values was and is: design, ref integrity and performance|