> SELECT array_accum(x) FROM (SELECT * FROM some_view ORDER BY x) AS tmp;
If you're using integers, you could use the int_array_accum or something from the intarray module which is a lot
faster.Ibelieve intarray also has a function for sorting integer arrays...
>
> BTW, the best alternative (in terms of execution performance) that comes
> into my mind is to create an aggregate that does the sorting right away
> while the values "come in" from the rows. But that'd probably take me
> some time to get right.
>