Do Layered Views/Relations Preserve Sort Order ?

Поиск
Список
Период
Сортировка
От Charles Sheridan
Тема Do Layered Views/Relations Preserve Sort Order ?
Дата
Msg-id 55F0C67B.8040009@swbell.net
обсуждение исходный текст
Ответы Re: Do Layered Views/Relations Preserve Sort Order ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Do Layered Views/Relations Preserve Sort Order ?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi All,

When there are several views defined on top of each other, are SELECTs 
on views that do not specify a SORT order guaranteed to preserve the 
cumulative sort order of the lower-level views ?

Is the answer true for any arbitrarily large set of layered views?

Is the answer the same if the layers of relations are a mix of views and 
tables ?


Best, Charles



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [PATCH] SQL function to report log message
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Do Layered Views/Relations Preserve Sort Order ?