Array of Arrays of int - Mailing list pgsql-sql

From Leo Fink
Subject Array of Arrays of int
Date
Msg-id 178c0af58f0514c54835d2e0723c525a@gmx.net
Whole thread Raw
Responses Re: Array of Arrays of int  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Enrico Weigelt
Date:
Subject: Re: trigger/rule question
Next
From: Enrico Weigelt
Date:
Subject: Re: pgtop, display PostgreSQL processes in `top' style