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
