Hippl,
I'm interested in calculating the median of a set of numbers. The algorithm requires that all values are known in advance (ie stored in an array). So the question is: how can I store everything first in an array so I can later process it given that I'd like this to be an aggregate function. I thought of creating an aggregate function and have the state_function() gather all the values of a group in an array and the final_function() to do the actuall median calculation on this array. But the intermmediate state cannot hold multiple values in an array (can it?)
Any ideas on how to go with this?
TIA,
thalis