ordering of selected rows from an ordered subselect

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема ordering of selected rows from an ordered subselect
Дата
Msg-id a97c77030702170132h51962513j929786b4f45aa50f@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "Ezequias Rodrigues da Rocha"
Дата:
Сообщение: Debug (is it PostgreSQL?)
Следующее
От: Louis-David Mitterrand
Дата:
Сообщение: sub-limiting a query