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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly