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...

--
Dennis

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 9 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedJan 27, '04 at 4:27p
activeJan 27, '04 at 10:31p
posts9
users5
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase