Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e1uXM-0006B6-0q for pgsql-sql@arkaria.postgresql.org; Tue, 10 Oct 2017 13:25:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e1uXL-0001lG-FB for pgsql-sql@arkaria.postgresql.org; Tue, 10 Oct 2017 13:25:31 +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_2) (envelope-from ) id 1e1uXK-0001dy-3D for pgsql-sql@postgresql.org; Tue, 10 Oct 2017 13:25:30 +0000 Received: from mtagatec.edf.fr ([163.114.23.150]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e1uXG-0003Gt-Js for pgsql-sql@postgresql.org; Tue, 10 Oct 2017 13:25:29 +0000 X-IronPort-AV: E=Sophos;i="5.42,505,1500933600"; d="scan'208";a="67193831" Received: from unknown (HELO webmail.intranet.edf.com) ([10.22.152.183]) by PCYDMZPIRGW003-back.edf.fr with ESMTP; 10 Oct 2017 15:25:04 +0200 Received: from PCYINTPEXMU001.NEOPROD.EDF.FR (10.22.152.238) by PCYINTPEXMU010.NEOPROD.EDF.FR (10.22.152.183) with Microsoft SMTP Server (TLS) id 15.0.1320.4; Tue, 10 Oct 2017 15:25:04 +0200 Received: from PCYINTPEXMU001.NEOPROD.EDF.FR (10.22.152.238) by PCYINTPEXMU001.NEOPROD.EDF.FR (10.22.152.238) with Microsoft SMTP Server (TLS) id 15.0.1320.4; Tue, 10 Oct 2017 15:25:04 +0200 Received: from PCYINTPEXMU001.NEOPROD.EDF.FR ([fe80::7c46:e173:1600:e88f]) by PCYINTPEXMU001.NEOPROD.EDF.FR ([fe80::7c46:e173:1600:e88f%14]) with mapi id 15.00.1320.000; Tue, 10 Oct 2017 15:25:04 +0200 From: ROS Didier To: "depesz@depesz.com" CC: "pgsql-sql@postgresql.org" Subject: Re: Need Help on SQL Query Thread-Topic: [SQL] Need Help on SQL Query Thread-Index: AQHTQb9Xq9emyQBJIUaeijOUb3NncaLdEqMA Date: Tue, 10 Oct 2017 13:25:03 +0000 Message-ID: References: <76762b7413164e9abff915ee223d2407@PCYINTPEXMU001.NEOPROD.EDF.FR> <20171010120015.GA17411@depesz.com> In-Reply-To: <20171010120015.GA17411@depesz.com> Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.22.153.70] x_exchange_neo: 1 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 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 SGkNCg0KSXQgd29ya3MgZ3JlYXQgISANClRoYW5rcyBhIGxvdA0KDQpEaWRp ZXIgUk9TIA0KRFNQL0NTUCBJVC1ETUEvU29sdXRpb25zIEdyb3VwZSBFREYv RXhwZXJ0aXNlIEFwcGxpY2F0aXZlDQpFeHBlcnRpc2UgU0dCRA0KMzIgQXZl bnVlIFBhYmxvIFBpY2Fzc28NCjkyMDAwIE5BTlRFUlJFIA0KQnVyZWF1wqA6 IEUyIDU2NUQgKGFpbGUgTm9yZC1Fc3QpDQpUw6lsLiA6IDAxLjc4LjY2LjYx LjE0DQoNCi0tLS0tTWVzc2FnZSBkJ29yaWdpbmUtLS0tLQ0KRGXCoDogZGVw ZXN6QGRlcGVzei5jb20gW21haWx0bzpkZXBlc3pAZGVwZXN6LmNvbV0gDQpF bnZvecOpwqA6IG1hcmRpIDEwIG9jdG9icmUgMjAxNyAxNDowMA0Kw4DCoDog Uk9TIERpZGllcg0KQ2PCoDogcGdzcWwtc3FsQHBvc3RncmVzcWwub3JnDQpP YmpldMKgOiBSZTogW1NRTF0gTmVlZCBIZWxwIG9uIFNRTCBRdWVyeQ0KDQpP biBUdWUsIE9jdCAxMCwgMjAxNyBhdCAxMTozODo1OUFNICswMDAwLCBST1Mg RGlkaWVyIHdyb3RlOg0KPiBIaQ0KPiAgICAgICAgICAgICAgICBJIG5lZWQg dG8gZ2V0IHRoZSBsaXN0IG9mIGZ1bmN0aW9ucyB3aGljaCBhcmUgZGVmaW5l ZCB3aXRoICJTRUNVUklUWS1ERUZJTkVSIiAuIEhvdyBjYW4gSSBnZXQgdGhp cyBpbiBTUUwgPw0KDQpzZWxlY3QgKiBmcm9tIHBnX3Byb2Mgd2hlcmUgcHJv c2VjZGVmOw0KDQpCZXN0IHJlZ2FyZHMsDQoNCmRlcGVzeg0KDQoKCgpDZSBt ZXNzYWdlIGV0IHRvdXRlcyBsZXMgcGnDqGNlcyBqb2ludGVzIChjaS1hcHLD qHMgbGUgJ01lc3NhZ2UnKSBzb250IMOpdGFibGlzIMOgIGwnaW50ZW50aW9u IGV4Y2x1c2l2ZSBkZXMgZGVzdGluYXRhaXJlcyBldCBsZXMgaW5mb3JtYXRp b25zIHF1aSB5IGZpZ3VyZW50IHNvbnQgc3RyaWN0ZW1lbnQgY29uZmlkZW50 aWVsbGVzLiBUb3V0ZSB1dGlsaXNhdGlvbiBkZSBjZSBNZXNzYWdlIG5vbiBj b25mb3JtZSDDoCBzYSBkZXN0aW5hdGlvbiwgdG91dGUgZGlmZnVzaW9uIG91 IHRvdXRlIHB1YmxpY2F0aW9uIHRvdGFsZSBvdSBwYXJ0aWVsbGUsIGVzdCBp bnRlcmRpdGUgc2F1ZiBhdXRvcmlzYXRpb24gZXhwcmVzc2UuCgpTaSB2b3Vz IG4nw6p0ZXMgcGFzIGxlIGRlc3RpbmF0YWlyZSBkZSBjZSBNZXNzYWdlLCBp bCB2b3VzIGVzdCBpbnRlcmRpdCBkZSBsZSBjb3BpZXIsIGRlIGxlIGZhaXJl IHN1aXZyZSwgZGUgbGUgZGl2dWxndWVyIG91IGQnZW4gdXRpbGlzZXIgdG91 dCBvdSBwYXJ0aWUuIFNpIHZvdXMgYXZleiByZcOndSBjZSBNZXNzYWdlIHBh ciBlcnJldXIsIG1lcmNpIGRlIGxlIHN1cHByaW1lciBkZSB2b3RyZSBzeXN0 w6htZSwgYWluc2kgcXVlIHRvdXRlcyBzZXMgY29waWVzLCBldCBkZSBuJ2Vu IGdhcmRlciBhdWN1bmUgdHJhY2Ugc3VyIHF1ZWxxdWUgc3VwcG9ydCBxdWUg Y2Ugc29pdC4gTm91cyB2b3VzIHJlbWVyY2lvbnMgw6lnYWxlbWVudCBkJ2Vu IGF2ZXJ0aXIgaW1tw6lkaWF0ZW1lbnQgbCdleHDDqWRpdGV1ciBwYXIgcmV0 b3VyIGR1IG1lc3NhZ2UuCgpJbCBlc3QgaW1wb3NzaWJsZSBkZSBnYXJhbnRp ciBxdWUgbGVzIGNvbW11bmljYXRpb25zIHBhciBtZXNzYWdlcmllIMOpbGVj dHJvbmlxdWUgYXJyaXZlbnQgZW4gdGVtcHMgdXRpbGUsIHNvbnQgc8OpY3Vy aXPDqWVzIG91IGTDqW51w6llcyBkZSB0b3V0ZSBlcnJldXIgb3UgdmlydXMu Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX18KClRoaXMgbWVzc2FnZSBhbmQgYW55IGF0dGFjaG1lbnRzICh0 aGUgJ01lc3NhZ2UnKSBhcmUgaW50ZW5kZWQgc29sZWx5IGZvciB0aGUgYWRk cmVzc2Vlcy4gVGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIE1l c3NhZ2UgaXMgY29uZmlkZW50aWFsLiBBbnkgdXNlIG9mIGluZm9ybWF0aW9u IGNvbnRhaW5lZCBpbiB0aGlzIE1lc3NhZ2Ugbm90IGluIGFjY29yZCB3aXRo IGl0cyBwdXJwb3NlLCBhbnkgZGlzc2VtaW5hdGlvbiBvciBkaXNjbG9zdXJl LCBlaXRoZXIgd2hvbGUgb3IgcGFydGlhbCwgaXMgcHJvaGliaXRlZCBleGNl cHQgZm9ybWFsIGFwcHJvdmFsLgoKSWYgeW91IGFyZSBub3QgdGhlIGFkZHJl c3NlZSwgeW91IG1heSBub3QgY29weSwgZm9yd2FyZCwgZGlzY2xvc2Ugb3Ig dXNlIGFueSBwYXJ0IG9mIGl0LiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlz IG1lc3NhZ2UgaW4gZXJyb3IsIHBsZWFzZSBkZWxldGUgaXQgYW5kIGFsbCBj b3BpZXMgZnJvbSB5b3VyIHN5c3RlbSBhbmQgbm90aWZ5IHRoZSBzZW5kZXIg aW1tZWRpYXRlbHkgYnkgcmV0dXJuIG1lc3NhZ2UuCgpFLW1haWwgY29tbXVu aWNhdGlvbiBjYW5ub3QgYmUgZ3VhcmFudGVlZCB0byBiZSB0aW1lbHkgc2Vj dXJlLCBlcnJvciBvciB2aXJ1cy1mcmVlLgoKLS0gClNlbnQgdmlhIHBnc3Fs LXNxbCBtYWlsaW5nIGxpc3QgKHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZykK VG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8v d3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXNxbAo=