On Mon, Jul 30, 2012 at 11:47 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > > > 2012/7/30 Thom Brown <t...@linux.com> >> >> On 30 July 2012 17:19, Pavel Stehule <pavel.steh...@gmail.com> wrote: >>> >>> Hello >>> >>> I seen nice trick based on window function >>> http://stackoverflow.com/questions/11700930/how-can-i-trim-a-text-array-in-postgresql >>> >>> but isn't it example of wrong evaluation? Result of row_number is not >>> correct >> >> >> Looks right to me. I guess the way to get the row_number they're after >> out of the result set would involve changing OVER () to OVER (ORDER BY >> unnest(myTextArrayColumn)) >> > > it looks like row_number is evaluated before SRF - this behave is absolutely > undefined - for me - more native behave is different evaluation.
If it was me, I'd have expanded the array with generate_series (as with the undocumented information_schema._pg_expandarray) and stacked the array with array() not array_agg(). merlin -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers