Date: Sat, 19 Apr 2014 08:44:51 -0700 (PDT)
From: David G Johnston <david.g.johnston@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1397922291602-5800802.post@n5.nabble.com>
In-Reply-To: <24744.1397920655@sss.pgh.pa.us>
References: 
 <CANNE3r1gyetpfiU_FWRtozD=cif7cphdWgz8RzPYYk-mKTrfVg@mail.gmail.com>
 <24744.1397920655@sss.pgh.pa.us>
Subject: Re: Default order of select datname from pg_database
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Tom Lane-2 wrote
> =?UTF-8?B?RWzDrWFzIERhdmlk?= &lt;

> elias.moreno.tec@

> &gt; writes:
>> By any change, does the following query have an "order by" by default
>> when
>> omitted?:
> 
>> select datname from pg_database;
> 
> No.  No SQL query ever has a "default" order by.

While not applicable here you can define a view to include an order by so
that a plain select on the view is indeed ordered even though the explicit
code provided by the user does not specify an order.

I'm doubting, though, that any of the information schema views do this.

David J.


--
View this message in context: http://postgresql.1045698.n5.nabble.com/Default-order-of-select-datname-from-pg-database-tp5800783p5800802.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin