Tom Lane wrote:
>Dennis Haney <davh(at)diku(dot)dk> writes:
>
>
>>There is no constraint on the order of 'a', so why is pull_up_subqueries
>>explicitly ignoring subqueries that contain an 'order by'?
>>
>>
>
>Because there would be no place to apply the sort operation.
>
Then why spend time doing it at all?
> If you are saying you don't want the sort to occur,
>
>
I'm saying the sort makes no sense. So why even bother executing it?
> why did you write it?
>
I believe the most common scenario would be that the subquery was
expanded from a view...
--
Dennis