Do Layered Views/Relations Preserve Sort Order ?

From: Charles Sheridan <cesheri(at)swbell(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Do Layered Views/Relations Preserve Sort Order ?
Date: 2015-09-09 23:53:31
Message-ID: 55F0C67B.8040009@swbell.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2015-09-10 00:44:59 Re: Do Layered Views/Relations Preserve Sort Order ?
Previous Message Andres Freund 2015-09-09 23:32:10 Re: [PATCH] SQL function to report log message