Stable sort?

From: "redhog" <redhog(at)redhog(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Stable sort?
Date: 2006-11-08 00:14:18
Message-ID: 1162944858.164852.173120@m7g2000cwm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wei Weng 2006-11-08 00:28:58 Question on inserting and querying at the same time.
Previous Message gurkan 2006-11-07 23:35:05 converting Informix outer to Postgres