Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aT1Hf-0003IZ-Oa for pgsql-sql@arkaria.postgresql.org; Tue, 09 Feb 2016 05:56:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aT1Hf-0005qM-BE for pgsql-sql@arkaria.postgresql.org; Tue, 09 Feb 2016 05:56:19 +0000 Received: from makus.postgresql.org ([174.143.35.229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aT1Hd-0005oQ-6e for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 05:56:17 +0000 Received: from mailuogwdur.emc.com ([128.221.224.79]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aT1FW-0007xc-IR for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 05:54:08 +0000 Received: from maildlpprd55.lss.emc.com (maildlpprd55.lss.emc.com [10.106.48.159]) by mailuogwprd53.lss.emc.com (Sentrion-MTA-4.3.1/Sentrion-MTA-4.3.0) with ESMTP id u195rvjS013683 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO); Tue, 9 Feb 2016 00:53:58 -0500 X-DKIM: OpenDKIM Filter v2.4.3 mailuogwprd53.lss.emc.com u195rvjS013683 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=emc.com; s=jan2013; t=1454997238; bh=Lm84CUsSFVejRKzt99trUrolack=; h=From:To:CC:Subject:Date:Message-ID:References:In-Reply-To: Content-Type:MIME-Version; b=PCMz1Uk7/YxxMz/B4IPpoV7nbJ0zMSMyGQ/W2AqSJAwb11OMJYvaAcT12N8C+76dG fE9ZJPRU8vtqyjSLZ/0pJYi71JrsxVttda99M/YydIvGXig66tQ+EImA1TR6weL25/ NauwkqVnywPLjihNbdOQZBycpp8HIseqgJ4Se0a8= X-DKIM: OpenDKIM Filter v2.4.3 mailuogwprd53.lss.emc.com u195rvjS013683 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:52:35 -0500 Received: from MXHUB224.corp.emc.com (MXHUB224.corp.emc.com [10.253.68.94]) by mailusrhubprd53.lss.emc.com (Sentrion-MTA-4.3.1/Sentrion-MTA-4.3.0) with ESMTP id u195rdnn013497 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=FAIL); Tue, 9 Feb 2016 00:53:40 -0500 Received: from MX105CL01.corp.emc.com ([fe80::e020:347b:74e3:4176]) by MXHUB224.corp.emc.com ([10.253.68.94]) with mapi id 14.03.0266.001; Tue, 9 Feb 2016 00:53:39 -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//+tLwCAAFMwUA== Date: Tue, 9 Feb 2016 05:53:38 +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_F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF1CMX105CL01corpem_" 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_F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF1CMX105CL01corpem_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 WWVzLiBpcyB0aGVyZSBhbiBvcHRpb24vY29uZmlndXJhdGlvbiB0byB0ZWxsIHRoZSBwb3N0Z3Jl cyBvcHRpbWl6ZXIvcGxhbm5lciB0byBnZW5lcmF0ZSBwbGFucyB0byBpbmNsdWRlIHRoZSBzb3J0 IG9yZGVyIGluc3RlYWQgb2Ygc3BlZWQ/DQoNCkZyb206IERhdmlkIEcuIEpvaG5zdG9uIFttYWls dG86ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb21dDQpTZW50OiBUdWVzZGF5LCBGZWJydWFyeSAw OSwgMjAxNiAxMToyMCBBTQ0KVG86IFZlbmthdGVzYW4sIFNla2hhcg0KQ2M6IFRvbSBMYW5lOyBw Z3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBbU1FMXSBRdWVzdGlvbiBvbiBQ b3N0Z3JlU1FMIERCIGJlaGF2aW9yIHcuci50IEpPSU4gYW5kIHNvcnQgb3JkZXIuDQoNCk9uIE1v bmRheSwgRmVicnVhcnkgOCwgMjAxNiwgVmVua2F0ZXNhbiwgU2VraGFyIDxzZWtoYXIudmVua2F0 ZXNhbkBlbWMuY29tPG1haWx0bzpzZWtoYXIudmVua2F0ZXNhbkBlbWMuY29tPj4gd3JvdGU6DQpJ cyB0aGVyZSBhIHdheSB0byB0ZWxsIHRoZSBvcHRpbWl6ZXIgdG8gcmV0YWluIHRoZSBzb3J0IG9y ZGVyIGlmIHRoYXQgaXMgcG9zc2libGUgcGxlYXNlPw0KDQoNCllvdSBtZWFuLCBiZXNpZGVzIHRo ZSBPUkRFUiBCWSBjbGF1c2U/DQoNCkRhdmlkIEouDQo= --_000_F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF1CMX105CL01corpem_ 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 Ow0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0Kc3Bhbi5FbWFpbFN0eWxlMTcNCgl7bXNv LXN0eWxlLXR5cGU6cGVyc29uYWwtcmVwbHk7DQoJZm9udC1mYW1pbHk6IkNhbGlicmkiLCJzYW5z LXNlcmlmIjsNCgljb2xvcjojMUY0OTdEO30NCi5Nc29DaHBEZWZhdWx0DQoJe21zby1zdHlsZS10 eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7fQ0K QHBhZ2UgV29yZFNlY3Rpb24xDQoJe3NpemU6OC41aW4gMTEuMGluOw0KCW1hcmdpbjoxLjBpbiAx LjBpbiAxLjBpbiAxLjBpbjt9DQpkaXYuV29yZFNlY3Rpb24xDQoJe3BhZ2U6V29yZFNlY3Rpb24x O30NCi0tPjwvc3R5bGU+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWRlZmF1bHRz IHY6ZXh0PSJlZGl0IiBzcGlkbWF4PSIxMDI2IiAvPg0KPC94bWw+PCFbZW5kaWZdLS0+PCEtLVtp ZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWxheW91dCB2OmV4dD0iZWRpdCI+DQo8bzppZG1h cCB2OmV4dD0iZWRpdCIgZGF0YT0iMSIgLz4NCjwvbzpzaGFwZWxheW91dD48L3htbD48IVtlbmRp Zl0tLT4NCjwvaGVhZD4NCjxib2R5IGxhbmc9IkVOLVVTIiBsaW5rPSJibHVlIiB2bGluaz0icHVy cGxlIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48 c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1 b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6IzFGNDk3RCI+WWVzLiBpcyB0aGVyZSBh biBvcHRpb24vY29uZmlndXJhdGlvbiB0byB0ZWxsIHRoZSBwb3N0Z3JlcyBvcHRpbWl6ZXIvcGxh bm5lciB0byBnZW5lcmF0ZSBwbGFucyB0byBpbmNsdWRlIHRoZSBzb3J0IG9yZGVyIGluc3RlYWQg b2Ygc3BlZWQ/PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNw YW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90 OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOiMxRjQ5N0QiPjxvOnA+Jm5ic3A7PC9vOnA+ PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxiPjxzcGFuIHN0eWxlPSJmb250LXNp emU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O1RhaG9tYSZxdW90OywmcXVvdDtzYW5zLXNlcmlm JnF1b3Q7Ij5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMC4wcHQ7Zm9u dC1mYW1pbHk6JnF1b3Q7VGFob21hJnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDsiPiBEYXZp ZCBHLiBKb2huc3RvbiBbbWFpbHRvOmRhdmlkLmcuam9obnN0b25AZ21haWwuY29tXQ0KPGJyPg0K PGI+U2VudDo8L2I+IFR1ZXNkYXksIEZlYnJ1YXJ5IDA5LCAyMDE2IDExOjIwIEFNPGJyPg0KPGI+ VG86PC9iPiBWZW5rYXRlc2FuLCBTZWtoYXI8YnI+DQo8Yj5DYzo8L2I+IFRvbSBMYW5lOyBwZ3Nx bC1zcWxAcG9zdGdyZXNxbC5vcmc8YnI+DQo8Yj5TdWJqZWN0OjwvYj4gUmU6IFtTUUxdIFF1ZXN0 aW9uIG9uIFBvc3RncmVTUUwgREIgYmVoYXZpb3Igdy5yLnQgSk9JTiBhbmQgc29ydCBvcmRlci48 bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwv bzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPk9uIE1vbmRheSwgRmVicnVhcnkgOCwgMjAx NiwgVmVua2F0ZXNhbiwgU2VraGFyICZsdDs8YSBocmVmPSJtYWlsdG86c2VraGFyLnZlbmthdGVz YW5AZW1jLmNvbSI+c2VraGFyLnZlbmthdGVzYW5AZW1jLmNvbTwvYT4mZ3Q7IHdyb3RlOjxvOnA+ PC9vOnA+PC9wPg0KPGRpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibXNv LW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG8iPjxzcGFuIHN0 eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssJnF1 b3Q7c2Fucy1zZXJpZiZxdW90Oztjb2xvcjojMUY0OTdEIj5JcyB0aGVyZSBhIHdheSB0byB0ZWxs IHRoZSBvcHRpbWl6ZXIgdG8gcmV0YWluIHRoZSBzb3J0IG9yZGVyIGlmIHRoYXQgaXMgcG9zc2li bGUgcGxlYXNlPzwvc3Bhbj48bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0 eWxlPSJtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0byI+ PG86cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+WW91IG1lYW4sIGJlc2lkZXMgdGhlIE9SREVSIEJZIGNsYXVzZT88bzpwPjwv bzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+RGF2aWQgSi4m bmJzcDs8bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF1CMX105CL01corpem_--