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
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