Hi,
I've started using ARRAY data type recently, and I fell into the
following problem:
When I have a relatively large ARRAY (like [1:500]) takeing an aggregate
function on its elements is not so easy. One has to iterate all the
elements, like this:
SELECT min(A[1]) as a1, min(A[2]) as a2, ...
This is because aggregate functions are not defined on ARRAY types. Or
may be there is an easier and more readable way to do that?
-R