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; ?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных