Is it just me, or is there any way a sort could be relevant in a subquery? (except on queries containing volatile functions)
select a.* from test1 a, (select id from test1 order by num) as b where a.id = b.id;
There is no constraint on the order of 'a', so why is pull_up_subqueries explicitly ignoring subqueries that contain an 'order by'?
-- Dennis
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
