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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]