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

Responses

• Re: Array of Arrays of int at 2005-05-02 04:11:06 from Tom Lane

pgsql-sql by date

Next:	From: Enrico Weigelt	Date: 2005-05-02 03:55:53
	Subject: Re: pgtop, display PostgreSQL processes in `top' style
Previous:	From: Enrico Weigelt	Date: 2005-05-02 03:41:00
	Subject: Re: trigger/rule question