Tom Lane wrote:
Dennis Haney <[EMAIL PROTECTED]> 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
|
