Dennis Haney <davh@diku.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. If you are
saying you don't want the sort to occur, why did you write it?
regards, tom lane
