On Jul 30, 2012, at 12:33, Thom Brown <t...@linux.com> wrote: > 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)) >
The better way would be to perform the unnest in a sub-select then attach the row number in the outer select. David J.
