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;
I don't see how it could be: SELECT * FROM (SELECT * FROM a ORDER BY x DESC) AS B ORDER BY x ASC; -- Richard Huxton Archonet Ltd