"Vitali Stupin" <[EMAIL PROTECTED]> writes:
> The error "invalid memory alloc request size 4294967293" apears when
> selecting array of empty arrays:
> select ARRAY['{}'::text[],'{}'::text[]];

I can get a core dump off it too, sometimes.  The problem is in
ExecEvalArray, which computes the dimension of the result as [1:2]
even though there are no elements to put in it.

Joe, what do you think about this?  Offhand I think that the only
workable definition is that this case yields another zero-dimensional
array, but maybe there is another choice?

We should probably check all the other array operations to see if they
have comparable problems.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to