Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aT20v-0005cX-Tj for pgsql-sql@arkaria.postgresql.org; Tue, 09 Feb 2016 06:43:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aT20u-0006xm-5q for pgsql-sql@arkaria.postgresql.org; Tue, 09 Feb 2016 06:43:04 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aT20s-0006xb-Dn for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 06:43:02 +0000 Received: from plane.gmane.org ([80.91.229.3]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aT20k-0000b5-RK for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 06:43:00 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1aT20h-0000mb-PG for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 07:42:51 +0100 Received: from 185.40.248.10 ([185.40.248.10]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 09 Feb 2016 07:42:51 +0100 Received: from spam_eater by 185.40.248.10 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 09 Feb 2016 07:42:51 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Thomas Kellerer Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Date: Tue, 9 Feb 2016 07:43:03 +0100 Lines: 10 Message-ID: References: <21082.1454994009@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 185.40.248.10 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 In-Reply-To: X-Pg-Spam-Score: -0.2 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Venkatesan, Sekhar schrieb am 09.02.2016 um 06:21: > So from what I understand, you say in postgres, if the sort order is not specified, > postgres returns results in any order. Am I right? This is nothing Postgres specific. This is true for *every* DBMS. Without an order by, the DBMS is free to return the rows in any order it wants. If you have seen a specific order in SQL Server that was pure coincidence and can *not* be relied upon. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql