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 ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Do Layered Views/Relations Preserve Sort Order ?  (Robert Haas <robertmhaas@gmail.com>)
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 ?