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.
Regards Pavel > -- > Thom >