[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, but

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