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
>

Reply via email to