BUG #3532: Can't rollup array of arrays

From: "James William Pye" <pgsql(at)jwp(dot)name>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3532: Can't rollup array of arrays
Date: 2007-08-10 18:26:55
Message-ID: 200708101826.l7AIQt5Y063989@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3532
Logged by: James William Pye
Email address: pgsql(at)jwp(dot)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(at)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(at)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)

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2007-08-10 21:38:02 Re: BUG #3512: buggy install + no manual support
Previous Message Peter Koczan 2007-08-10 15:59:15 Re: BUG #3504: Some listening sessions never return from writing, problems ensue