Dennis Haney kirjutas T, 27.01.2004 kell 21:08: > 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...
And why is it written on the outer level of view. AFAIK any select from that view is also free to ignore it. ----------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings