Re: strange evaluation Window function and SRF functions?

2012/7/30 Thom Brown <thom(at)linux(dot)com>

> On 30 July 2012 17:19, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
>