[SQL] Array of Arrays of int

2005-05-01 Thread Leo Fink
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, bu

Re: [SQL] Array of Arrays of int

2005-05-01 Thread Leo Fink
Hello Tom. Am 02.05.2005 um 06:11 schrieb Tom Lane: Leo Fink <[EMAIL PROTECTED]> writes: Why does select array(select array[1,2]); give me an error: "could not find array type for data type integer[]"? We don't do arrays of arrays. You seem to be hoping for a 2-D arra