Postgres Pro
Downloads
Home   >   mailing lists

Do Layered Views/Relations Preserve Sort Order ? - Mailing list pgsql-hackers

From Charles Sheridan
Subject Do Layered Views/Relations Preserve Sort Order ?
Date
Msg-id 55F0C67B.8040009@swbell.net
Whole thread Raw
Responses Re: Do Layered Views/Relations Preserve Sort Order ?
Re: Do Layered Views/Relations Preserve Sort Order ?
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] SQL function to report log message
Next
From: "David G. Johnston"
Date:
Subject: Re: Do Layered Views/Relations Preserve Sort Order ?