Thread: BUG #3532: Can't rollup array of arrays

BUG #3532: Can't rollup array of arrays

From
"James William Pye"
Date:
The following bug has been logged online:

Bug reference:      3532
Logged by:          James William Pye
Email address:      pgsql@jwp.name
PostgreSQL version: 8.2
Operating system:   FreeBSD
Description:        Can't rollup array of arrays
Details:

Dunno about the spec, but I would think this should work:

tinman@localhost/tinman[]=# SELECT array(select array[table_name,
column_name] FROM information_schema.columns LIMIT 10);
ERROR:  could not find array type for datatype character varying[]

tinman@localhost/tinman[]=# SELECT version();
                                            version

----------------------------------------------------------------------------
--------------------
 PostgreSQL 8.2.4 on i386-portbld-freebsd6.2, compiled by GCC cc (GCC) 3.4.6
[FreeBSD] 20060305
(1 row)

The expectation is the production of an array like:
'{{table_foo,column_bar},{table_foo,column_bar2},...}'.

No? (yeah, it may be more of a feature request than a bug)