Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aT1Aa-0002t7-5k for pgsql-sql@arkaria.postgresql.org; Tue, 09 Feb 2016 05:49:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aT1AZ-0003NL-Oe for pgsql-sql@arkaria.postgresql.org; Tue, 09 Feb 2016 05:48:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aT1AX-0003LM-II for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 05:48:57 +0000 Received: from mailuogwdur.emc.com ([128.221.224.79]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aT1AT-0006Xz-9l for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 05:48:56 +0000 Received: from maildlpprd55.lss.emc.com (maildlpprd55.lss.emc.com [10.106.48.159]) by mailuogwprd54.lss.emc.com (Sentrion-MTA-4.3.1/Sentrion-MTA-4.3.0) with ESMTP id u195mlQY030714 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO); Tue, 9 Feb 2016 00:48:48 -0500 X-DKIM: OpenDKIM Filter v2.4.3 mailuogwprd54.lss.emc.com u195mlQY030714 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=emc.com; s=jan2013; t=1454996928; bh=3BmQLXi43YYI+rWJemLDAtWnynA=; h=From:To:CC:Subject:Date:Message-ID:References:In-Reply-To: Content-Type:MIME-Version; b=sZPzO5qtM1ZKJi4iUm0crI9wEfb261AWtslJjxCqeMru2Q1mq54nW2w1Y5LRh2PQ2 c6fVY856Wf8BWiO16K87KYlIqoOIfNHQto9EUb520RF3/vuS69C8XIfY1cFRMtOFu7 7ampKrusokpVe+iBo7VEeETdJ5bQaAZAOIUh1us4= X-DKIM: OpenDKIM Filter v2.4.3 mailuogwprd54.lss.emc.com u195mlQY030714 Received: from mailusrhubprd53.lss.emc.com (mailusrhubprd53.lss.emc.com [10.106.48.18]) by maildlpprd55.lss.emc.com (RSA Interceptor); Tue, 9 Feb 2016 00:47:29 -0500 Received: from MXHUB227.corp.emc.com (MXHUB227.corp.emc.com [10.253.68.97]) by mailusrhubprd53.lss.emc.com (Sentrion-MTA-4.3.1/Sentrion-MTA-4.3.0) with ESMTP id u195mXlE011767 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=FAIL); Tue, 9 Feb 2016 00:48:33 -0500 Received: from MX105CL01.corp.emc.com ([fe80::e020:347b:74e3:4176]) by MXHUB227.corp.emc.com ([10.253.68.97]) with mapi id 14.03.0266.001; Tue, 9 Feb 2016 00:48:32 -0500 From: "Venkatesan, Sekhar" To: "David G. Johnston" CC: Tom Lane , "pgsql-sql@postgresql.org" Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Thread-Topic: [SQL] Question on PostgreSQL DB behavior w.r.t JOIN and sort order. Thread-Index: AdFi8MH6WiSn/w2ETze/qHqqolOx7gAL+aqAAAo3P3D//7tyAIAAU6MA Date: Tue, 9 Feb 2016 05:48:32 +0000 Message-ID: References: <21082.1454994009@sss.pgh.pa.us> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.30.85.98] Content-Type: multipart/alternative; boundary="_000_F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF07MX105CL01corpem_" MIME-Version: 1.0 X-Sentrion-Hostname: mailusrhubprd53.lss.emc.com X-RSA-Classifications: public X-Pg-Spam-Score: -4.6 (----) 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 --_000_F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF07MX105CL01corpem_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SXMgdGhlcmUgYSB3YXkgdG8gdGVsbCB0aGUgb3B0aW1pemVyIHRvIHJldGFpbiB0aGUgc29ydCBv cmRlciBpZiB0aGF0IGlzIHBvc3NpYmxlIHBsZWFzZT8NCg0KRnJvbTogRGF2aWQgRy4gSm9obnN0 b24gW21haWx0bzpkYXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbV0NClNlbnQ6IFR1ZXNkYXksIEZl YnJ1YXJ5IDA5LCAyMDE2IDExOjE3IEFNDQpUbzogVmVua2F0ZXNhbiwgU2VraGFyDQpDYzogVG9t IExhbmU7IHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6IFtTUUxdIFF1ZXN0 aW9uIG9uIFBvc3RncmVTUUwgREIgYmVoYXZpb3Igdy5yLnQgSk9JTiBhbmQgc29ydCBvcmRlci4N Cg0KT24gTW9uZGF5LCBGZWJydWFyeSA4LCAyMDE2LCBWZW5rYXRlc2FuLCBTZWtoYXIgPHNla2hh ci52ZW5rYXRlc2FuQGVtYy5jb208bWFpbHRvOnNla2hhci52ZW5rYXRlc2FuQGVtYy5jb20+PiB3 cm90ZToNCg0KU28gZnJvbSB3aGF0IEkgdW5kZXJzdGFuZCwgeW91IHNheSBpbiBwb3N0Z3Jlcywg aWYgdGhlIHNvcnQgb3JkZXIgaXMgbm90IHNwZWNpZmllZCwgcG9zdGdyZXMgcmV0dXJucyByZXN1 bHRzIGluIGFueSBvcmRlci4gQW0gSSByaWdodD8NClllcy4gIEl0IHdpbGwgb3B0aW1pemUgZm9y IHNwZWVkIHdpdGhvdXQgYW55IHJlZ2FyZCBmb3IgbWFpbnRhaW5pbmcgYW55IGtpbmQgb2Ygb3Jk ZXJpbmcuICBZb3UgbWF5IGdldCB0aGUgZGVzaXJlZCBvcmRlciBmb3IgdmFyaW91cyByZWFzb25z IGJ1dCB3aXRob3V0IE9SREVSIEJZIHlvdSBjYW5ub3QgYmUgZ3VhcmFudGVlZC4NCg0KRGF2aWQg Si4NCg== --_000_F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF07MX105CL01corpem_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTQgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 Q2FsaWJyaTsNCglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9DQpAZm9udC1mYWNlDQoJ e2ZvbnQtZmFtaWx5OlRhaG9tYTsNCglwYW5vc2UtMToyIDExIDYgNCAzIDUgNCA0IDIgNDt9DQov KiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3JtYWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1z b05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0b206LjAwMDFwdDsNCglmb250LXNp emU6MTIuMHB0Ow0KCWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLCJzZXJpZiI7fQ0KYTps aW5rLCBzcGFuLk1zb0h5cGVybGluaw0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJY29sb3I6 Ymx1ZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30NCmE6dmlzaXRlZCwgc3Bhbi5Nc29I eXBlcmxpbmtGb2xsb3dlZA0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJY29sb3I6cHVycGxl Ow0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KcA0KCXttc28tc3R5bGUtcHJpb3JpdHk6 OTk7DQoJbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87DQoJbWFyZ2luLXJpZ2h0OjBpbjsNCgltc28t bWFyZ2luLWJvdHRvbS1hbHQ6YXV0bzsNCgltYXJnaW4tbGVmdDowaW47DQoJZm9udC1zaXplOjEy LjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIiwic2VyaWYiO30NCnNwYW4uRW1h aWxTdHlsZTE4DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFtaWx5 OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7DQoJY29sb3I6IzFGNDk3RDt9DQouTXNvQ2hwRGVmYXVs dA0KCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTsNCglmb250LWZhbWlseToiQ2FsaWJyaSIs InNhbnMtc2VyaWYiO30NCkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjguNWluIDExLjBpbjsN CgltYXJnaW46MS4waW4gMS4waW4gMS4waW4gMS4waW47fQ0KZGl2LldvcmRTZWN0aW9uMQ0KCXtw YWdlOldvcmRTZWN0aW9uMTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0K PG86c2hhcGVkZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1sPjwh W2VuZGlmXS0tPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpleHQ9 ImVkaXQiPg0KPG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVsYXlv dXQ+PC94bWw+PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1VUyIgbGluaz0i Ymx1ZSIgdmxpbms9InB1cnBsZSI+DQo8ZGl2IGNsYXNzPSJXb3JkU2VjdGlvbjEiPg0KPHAgY2xh c3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7Q2FsaWJyaSZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOiMxRjQ5N0Qi PklzIHRoZXJlIGEgd2F5IHRvIHRlbGwgdGhlIG9wdGltaXplciB0byByZXRhaW4gdGhlIHNvcnQg b3JkZXIgaWYgdGhhdCBpcyBwb3NzaWJsZSBwbGVhc2U/PG86cD48L286cD48L3NwYW4+PC9wPg0K PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1m YW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOiMx RjQ5N0QiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwi PjxiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O1RhaG9t YSZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7Ij5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4gc3R5 bGU9ImZvbnQtc2l6ZToxMC4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7VGFob21hJnF1b3Q7LCZxdW90 O3NhbnMtc2VyaWYmcXVvdDsiPiBEYXZpZCBHLiBKb2huc3RvbiBbbWFpbHRvOmRhdmlkLmcuam9o bnN0b25AZ21haWwuY29tXQ0KPGJyPg0KPGI+U2VudDo8L2I+IFR1ZXNkYXksIEZlYnJ1YXJ5IDA5 LCAyMDE2IDExOjE3IEFNPGJyPg0KPGI+VG86PC9iPiBWZW5rYXRlc2FuLCBTZWtoYXI8YnI+DQo8 Yj5DYzo8L2I+IFRvbSBMYW5lOyBwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmc8YnI+DQo8Yj5TdWJq ZWN0OjwvYj4gUmU6IFtTUUxdIFF1ZXN0aW9uIG9uIFBvc3RncmVTUUwgREIgYmVoYXZpb3Igdy5y LnQgSk9JTiBhbmQgc29ydCBvcmRlci48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0i TXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPk9u IE1vbmRheSwgRmVicnVhcnkgOCwgMjAxNiwgVmVua2F0ZXNhbiwgU2VraGFyICZsdDs8YSBocmVm PSJtYWlsdG86c2VraGFyLnZlbmthdGVzYW5AZW1jLmNvbSI+c2VraGFyLnZlbmthdGVzYW5AZW1j LmNvbTwvYT4mZ3Q7IHdyb3RlOjxvOnA+PC9vOnA+PC9wPg0KPGRpdj4NCjxkaXY+DQo8cD5TbyBm cm9tIHdoYXQgSSB1bmRlcnN0YW5kLCB5b3Ugc2F5IGluIHBvc3RncmVzLCBpZiB0aGUgc29ydCBv cmRlciBpcyBub3Qgc3BlY2lmaWVkLCBwb3N0Z3JlcyByZXR1cm5zIHJlc3VsdHMgaW4gYW55IG9y ZGVyLiBBbSBJIHJpZ2h0PzxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8L2Rpdj4NCjxkaXY+DQo8 cCBjbGFzcz0iTXNvTm9ybWFsIj5ZZXMuJm5ic3A7IEl0IHdpbGwgb3B0aW1pemUgZm9yIHNwZWVk IHdpdGhvdXQgYW55IHJlZ2FyZCBmb3IgbWFpbnRhaW5pbmcgYW55IGtpbmQgb2Ygb3JkZXJpbmcu Jm5ic3A7IFlvdSBtYXkgZ2V0IHRoZSBkZXNpcmVkIG9yZGVyIGZvciB2YXJpb3VzIHJlYXNvbnMg YnV0IHdpdGhvdXQgT1JERVIgQlkmbmJzcDt5b3UgY2Fubm90IGJlIGd1YXJhbnRlZWQuPG86cD48 L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNw OzwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkRhdmlkIEou Jm5ic3A7PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF07MX105CL01corpem_--