Home > mailing lists

order is preserved by outer select? - Mailing list pgsql-general

From	Joshua N Pritikin
Subject	order is preserved by outer select?
Date	July 13, 2007 08:34:51
Msg-id	20070713083610.GC467@always.joy.eth.net Whole thread Raw
Responses	Re: order is preserved by outer select? (Richard Huxton <dev@archonet.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: PFC
Date: 13 July 2007, 07:52:44
Subject: Re: optimizing postgres

From: Richard Huxton
Date: 13 July 2007, 08:45:32
Subject: Re: order is preserved by outer select?

order is preserved by outer select? - Mailing list pgsql-general

Previous

Next