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 по дате отправления: