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...
In response to
pgsql-hackers by date
|Next:||From: Dave Cramer||Date: 2004-01-27 19:09:13|
|Subject: Re: index scan with functional indexes -- solved|
|Previous:||From: Bruce Momjian||Date: 2004-01-27 19:07:44|
|Subject: Re: Mixing threaded and non-threaded|