ordering of selected rows from an ordered subselect - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject ordering of selected rows from an ordered subselect
Date
Msg-id a97c77030702170132h51962513j929786b4f45aa50f@mail.gmail.com
Whole thread Raw
Responses Re: ordering of selected rows from an ordered subselect  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: ordering of selected rows from an ordered subselect  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hi,

we know that rows in a table are not stored in any particular order
and explicit order by clause is required to get data in any particular
order.

but does it apply to select queries from ordered subselects also ?
eg

select   id , name , expensive_func(name)  from       ( select id , name from tab  order by c1 desc limit 15)  as foo
;

is it guaranteed that the final result is order by c1 ?

Regds
mallah.


pgsql-sql by date:

Previous
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Debug (is it PostgreSQL?)
Next
From: Louis-David Mitterrand
Date:
Subject: sub-limiting a query