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 array, which is something fundamen

Re: [SQL] Array of Arrays of int

2005-05-01 Thread 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 array, which is something fundamentally different (even though some programming

[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