Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aT1am-0004Ix-32 for pgsql-sql@arkaria.postgresql.org; Tue, 09 Feb 2016 06:16:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aT1al-0004oB-Jc for pgsql-sql@arkaria.postgresql.org; Tue, 09 Feb 2016 06:16:03 +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 1aT1Zm-0003fM-Aa for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 06:15:02 +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 1aT1Zh-0008O1-UT for pgsql-sql@postgresql.org; Tue, 09 Feb 2016 06:14:59 +0000 Received: from maildlpprd54.lss.emc.com (maildlpprd54.lss.emc.com [10.106.48.158]) by mailuogwprd52.lss.emc.com (Sentrion-MTA-4.3.1/Sentrion-MTA-4.3.0) with ESMTP id u196Eq2R028616 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO); Tue, 9 Feb 2016 01:14:53 -0500 X-DKIM: OpenDKIM Filter v2.4.3 mailuogwprd52.lss.emc.com u196Eq2R028616 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=emc.com; s=jan2013; t=1454998494; bh=H0ZhnUeaQGe0stgkGYUswOjrHZ8=; h=From:To:CC:Subject:Date:Message-ID:References:In-Reply-To: Content-Type:Content-Transfer-Encoding:MIME-Version; b=LEmG1hiCRLZt37CT2IE6lMvRsIwgqY17EOS6ivudogc0+qwuFeFi+MOcKcQRsxjd7 tnORXQsM3zgOMNRdlv/YmqieUIk5xPaZnjJ1e/DGtq2AYf/oK+YTgNsDh69tDrt+eu ISQZNAmZ1lX8XxznCithbbMP8Rr8jFmAdcFouSRo= X-DKIM: OpenDKIM Filter v2.4.3 mailuogwprd52.lss.emc.com u196Eq2R028616 Received: from mailusrhubprd52.lss.emc.com (mailusrhubprd52.lss.emc.com [10.106.48.25]) by maildlpprd54.lss.emc.com (RSA Interceptor); Tue, 9 Feb 2016 01:14:15 -0500 Received: from MXHUB202.corp.emc.com (MXHUB202.corp.emc.com [10.253.68.28]) by mailusrhubprd52.lss.emc.com (Sentrion-MTA-4.3.1/Sentrion-MTA-4.3.0) with ESMTP id u196EgR5013391 (version=TLSv1.2 cipher=AES128-SHA256 bits=128 verify=FAIL); Tue, 9 Feb 2016 01:14:42 -0500 Received: from MX105CL01.corp.emc.com ([fe80::e020:347b:74e3:4176]) by MXHUB202.corp.emc.com ([10.253.68.28]) with mapi id 14.03.0266.001; Tue, 9 Feb 2016 01:14:41 -0500 From: "Venkatesan, Sekhar" To: Adrian Klaver , "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//+tLwCAAFMwUP//sBGAgABRe8A= Date: Tue, 9 Feb 2016 06:14:41 +0000 Message-ID: References: <21082.1454994009@sss.pgh.pa.us> <56B980D1.7010509@aklaver.com> In-Reply-To: <56B980D1.7010509@aklaver.com> 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: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Sentrion-Hostname: mailusrhubprd52.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 TXkgY29uY2VybiBoZXJlIGlzIHRoYXQgSSB3YW50IHRvIG1haW50YWluIGNv bnNpc3RlbmN5ICggaW4gb3VyIGFwcGxpY2F0aW9uIHRvIHJldGFpbiBzb3J0 IG9yZGVyKSBiZXR3ZWVuIGRpZmZlcmVudCBkYXRhYmFzZXMuDQpJIGRvbid0 IHNlZSB0aGUgaXNzdWUgaW4gU1FMIFNlcnZlciBhbmQgT3JhY2xlIGRhdGFi YXNlcy4gDQoiU0VMRUNUIEtIXy5yX29iamVjdF9pZCwgS0hfLm9iamVjdF9u YW1lIEZST00gICAgICAgICBkYm8uZG1fbG9jYXRpb25fcyBBUyBaU18gSU5O RVIgSk9JTg0KICAgICAgICAgICAgICAgICAgICAgIGRiby5kbV9zeXNvYmpl Y3RfcyBBUyBLSF8gT04gWlNfLnJfb2JqZWN0X2lkID0gS0hfLnJfb2JqZWN0 X2lkICINCg0KVGhlIGFib3ZlIHF1ZXJ5IGlzIHNvcnRlZCBiYXNlZCBvbiB0 aGUgZmlyc3QgY29sdW1uIGluIHRoZSBzZWxlY3QgbGlzdC4gU2FtZSBpcyBu b3QgaGFwcGVuaW5nIGluIFBvc3RncmVTUUwuDQpJcyB0aGlzIHNvbWV0aGlu ZyB0byBkbyB3aXRoIGNvbGxhdGlvbiBzZXR0aW5nIGluIGRhdGFiYXNlPw0K DQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogQWRyaWFuIEts YXZlciBbbWFpbHRvOmFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb21dIA0KU2Vu dDogVHVlc2RheSwgRmVicnVhcnkgMDksIDIwMTYgMTE6MzIgQU0NClRvOiBW ZW5rYXRlc2FuLCBTZWtoYXI7IERhdmlkIEcuIEpvaG5zdG9uDQpDYzogVG9t IExhbmU7IHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6 IFtTUUxdIFF1ZXN0aW9uIG9uIFBvc3RncmVTUUwgREIgYmVoYXZpb3Igdy5y LnQgSk9JTiBhbmQgc29ydCBvcmRlci4NCg0KT24gMDIvMDgvMjAxNiAwOTo1 MyBQTSwgVmVua2F0ZXNhbiwgU2VraGFyIHdyb3RlOg0KPiBZZXMuIGlzIHRo ZXJlIGFuIG9wdGlvbi9jb25maWd1cmF0aW9uIHRvIHRlbGwgdGhlIHBvc3Rn cmVzIA0KPiBvcHRpbWl6ZXIvcGxhbm5lciB0byBnZW5lcmF0ZSBwbGFucyB0 byBpbmNsdWRlIHRoZSBzb3J0IG9yZGVyIGluc3RlYWQgDQo+IG9mIHNwZWVk Pw0KDQpXaGF0IGNvbHVtbnMgaW4gYSB0YWJsZSB3b3VsZCB0aGF0IGJlIGFu ZCB0aGVuIHdoYXQgb3JkZXI/DQoNCj4NCj4gKkZyb206KkRhdmlkIEcuIEpv aG5zdG9uIFttYWlsdG86ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb21dDQo+ ICpTZW50OiogVHVlc2RheSwgRmVicnVhcnkgMDksIDIwMTYgMTE6MjAgQU0N Cj4gKlRvOiogVmVua2F0ZXNhbiwgU2VraGFyDQo+ICpDYzoqIFRvbSBMYW5l OyBwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcNCj4gKlN1YmplY3Q6KiBSZTog W1NRTF0gUXVlc3Rpb24gb24gUG9zdGdyZVNRTCBEQiBiZWhhdmlvciB3LnIu dCBKT0lOIGFuZCANCj4gc29ydCBvcmRlci4NCj4NCj4gT24gTW9uZGF5LCBG ZWJydWFyeSA4LCAyMDE2LCBWZW5rYXRlc2FuLCBTZWtoYXIgDQo+IDxzZWto YXIudmVua2F0ZXNhbkBlbWMuY29tIDxtYWlsdG86c2VraGFyLnZlbmthdGVz YW5AZW1jLmNvbT4+IHdyb3RlOg0KPg0KPiBJcyB0aGVyZSBhIHdheSB0byB0 ZWxsIHRoZSBvcHRpbWl6ZXIgdG8gcmV0YWluIHRoZSBzb3J0IG9yZGVyIGlm IHRoYXQgDQo+IGlzIHBvc3NpYmxlIHBsZWFzZT8NCj4NCj4gWW91IG1lYW4s IGJlc2lkZXMgdGhlIE9SREVSIEJZIGNsYXVzZT8NCj4NCj4gRGF2aWQgSi4N Cj4NCg0KDQotLQ0KQWRyaWFuIEtsYXZlcg0KYWRyaWFuLmtsYXZlckBha2xh dmVyLmNvbQ0KCi0tIApTZW50IHZpYSBwZ3NxbC1zcWwgbWFpbGluZyBsaXN0 IChwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0 byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y Zy9tYWlscHJlZi9wZ3NxbC1zcWwK