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