On Mon, Dec 5, 2011 at 2:05 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> maxim.boguk@gmail.com writes:
> > SELECT ARRAY(SELECT ...)
> > doesn't work when subselect return any array.
> > Is that syntax supposed to work with anyarray types?
>
> No.
>
> regards, tom lane
>
Hi.
Thank you very much for answer.
Ok the second problem (possible related to first becuse error is the same):
array_agg doesn't work with anyarray as well:
sports=# select array_agg(val) FROM (SELECT array[1,2]::integer[] as val
UNION ALL SELECT array[3,4]::integer[]) as t;
ERROR: could not find array type for data type integer[]
PS: I try create two-dimentional integer array from query results:
select val1::integer, val2::integer from somequery
to get integer[][] with content like:
[[val1-1,val1-2], [val2-1, val2-2], val[3-1, val3-2]... ]
Is there any way to perform that task it with reasonable efficiency?
--
Maxim Boguk
Senior Postgresql DBA.