Dennis Haney kirjutas T, 27.01.2004 kell 21:08:
> Tom Lane wrote:
> > 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.
> 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