At Wed, 18 May 2005 19:54:08 +0200,
PFC wrote:
> > 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. I believe
> intarray also has a function for sorting integer arrays...
No, unfortunately I'm using strings in "real-life" (my example is
perhaps a bit over-simplified).
Let me make my original question a bit more precise: How do I best
transform a column of varchars into a *sorted* array?
--
Felix E. Klee