Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group