redhog wrote: > Is sorting in PostgreSQL stable over subqueries, that is, is > > select * from (select * from A order by x) as B order by y; > > equivalent with > > select * from A order by y, x;
Seems as easy to try as to guess. If I did this query right, it seems not. select * from (select random()>0.5 as a, random()>0.5 as b from generate_series(1,10) order by a) as x order by b; a | b ---+--- f | t f | f f | f f | f f | t f | f t | t t | t t | t t | f (10 rows) OTOH, HEY, why isn't that result ordered by 'b' instead of by 'a' (or am I misreading my query or the results)? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
