order is preserved by outer select?

From: Joshua N Pritikin <jpritikin(at)pobox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: order is preserved by outer select?
Date: 2007-07-13 08:36:10
Message-ID: 20070713083610.GC467@always.joy.eth.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here's another easy (stupid?) question:

SELECT data.* FROM (SELECT * FROM foo ORDER BY bar) AS data

Will the returned rows still be ordered by bar?

--
Make April 15 just another day, visit http://fairtax.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-07-13 08:45:19 Re: order is preserved by outer select?
Previous Message PFC 2007-07-13 07:54:04 Re: optimizing postgres