X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A00725338B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  2 May 2005 00:50:48 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 22481-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  2 May 2005 03:50:40 +0000 (GMT)
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by svr1.postgresql.org (Postfix) with SMTP id 59DBE53243
	for <pgsql-sql@postgresql.org>; Mon,  2 May 2005 00:50:38 -0300 (ADT)
Received: (qmail invoked by alias); 02 May 2005 03:50:37 -0000
Received: from ip26.65.1311D-CUD12K-02.ish.de (EHLO [192.168.1.1])
	[62.143.65.26]
	by mail.gmx.net (mp004) with SMTP; 02 May 2005 05:50:37 +0200
X-Authenticated: #3894346
Mime-Version: 1.0 (Apple Message framework v622)
Content-Transfer-Encoding: 7bit
Message-Id: <178c0af58f0514c54835d2e0723c525a@gmx.net>
Content-Type: text/plain; charset=US-ASCII; format=flowed
To: pgsql-sql@postgresql.org
From: Leo Fink <leo.fink@gmx.net>
Subject: Array of Arrays of int
Date: Mon, 2 May 2005 05:50:37 +0200
X-Mailer: Apple Mail (2.622)
X-Y-GMX-Trusted: 0
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200505/5
X-Sequence-Number: 21318

Why does

select array(select array[1,2]);

give me an error: "could not find array type for data type integer[]"?

Is there a type-cast missing, or is this generally impossible? I was 
expecting something like

{{1,2}}

In my real-world application, the subquery returns more than one pair 
of ints, but I think it all boils down to this simpler example. I am 
using version 7.4 of PostgreSQL.

Thanks a lot,
Leo