BUG #3532: Can't rollup array of arrays
| От | James William Pye |
|---|---|
| Тема | BUG #3532: Can't rollup array of arrays |
| Дата | |
| Msg-id | 200708101826.l7AIQt5Y063989@wwwmaster.postgresql.org обсуждение |
| Список | pgsql-bugs |
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)
В списке pgsql-bugs по дате отправления: