Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0OII-00053b-Fn for pgsql-docs@arkaria.postgresql.org; Thu, 13 Sep 2018 09:52:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g0OIG-0005xm-4M for pgsql-docs@arkaria.postgresql.org; Thu, 13 Sep 2018 09:52:12 +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.89) (envelope-from ) id 1g0JsN-0004jQ-BX for pgsql-docs@lists.postgresql.org; Thu, 13 Sep 2018 05:09:11 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g0JsF-0007f5-Fa for pgsql-docs@lists.postgresql.org; Thu, 13 Sep 2018 05:09:10 +0000 Content-Type: multipart/mixed; boundary="===============4511479949613966115==" MIME-Version: 1.0 Subject: join tutorial: table joined on itself To: pgsql-docs@lists.postgresql.org From: =?utf-8?q?PG_Doc_comments_form?= Cc: shadiakiki1986@gmail.com Reply-To: shadiakiki1986@gmail.com, pgsql-docs@lists.postgresql.org Date: Thu, 13 Sep 2018 05:08:33 +0000 Message-ID: <153681531312.22350.4392709233447748924@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4511479949613966115== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMC9zdGF0 aWMvdHV0b3JpYWwtam9pbi5odG1sCkRlc2NyaXB0aW9uOgoKVGhhbmtzIGZvciB0aGUgZWZmb3J0 IGZvciB0aGlzIHdvbmRlcmZ1bCB0dXRvcmlhbC4NClRoZSBsYXN0IHRhYmxlIHRoYXQgaWxsdXN0 cmF0ZXMgam9pbmluZyBhIHRhYmxlIG9uIGl0c2VsZiBzaG93cyB0aGF0IFNhbgpGcmFuc2lzY28g aGFzIGB0ZW1wX2xvYCBsb3dlciB0aGFuIGl0c2VsZiBhbmQgYHRlbXBfaGlgIGhpZ2hlciB0aGFu IGl0c2VsZiwKd2l0aG91dCBpbmNsdWRpbmcgdGhlIGRhdGVzIG9mIHRoZSB0ZW1wZXJhdHVyZXMu IEkgYmVsaWV2ZSBpdCB3b3VsZCBiZQpjbGVhcmVyIChkYXRhLXdpc2UpIGlmIHRoZSB0YWJsZSBp bmNsdWRlZCB0aGUgZGF0ZXMgZmllbGRzIGBXMS5kYXRlIGFzIGRhdGVgCmFuZCBgVzIuZGF0ZSBh cyBkYXRlYCwgbWFraW5nIHRoZSB3aG9sZSBleGFtcGxlIG91dHB1dCBsb29rIGFzIGZvbGxvd3MN Cg0KYGBgDQpTRUxFQ1QgVzEuY2l0eSwgVzEuZGF0ZSBhcyBkYXRlLCBXMS50ZW1wX2xvIEFTIGxv dywgVzEudGVtcF9oaSBBUyBoaWdoDQogICAgVzIuY2l0eSwgVzIuZGF0ZSBhcyBkYXRlLCBXMi50 ZW1wX2xvIEFTIGxvdywgVzIudGVtcF9oaSBBUyBoaWdoDQogICAgRlJPTSB3ZWF0aGVyIFcxLCB3 ZWF0aGVyIFcyDQogICAgV0hFUkUgVzEudGVtcF9sbyA8IFcyLnRlbXBfbG8NCiAgICBBTkQgVzEu dGVtcF9oaSA+IFcyLnRlbXBfaGk7DQoNCiAgICAgY2l0eSAgICAgIHwgZGF0ZSB8IGxvdyB8IGhp Z2ggfCAgICAgY2l0eSAgICAgIHwgbG93IHwgaGlnaA0KLS0tLS0tLS0tLS0tLS0tKy0tLS0tKy0t LS0tKy0tLS0tLSstLS0tLS0tLS0tLS0tLS0rLS0tLS0rLS0tLS0tDQogU2FuIEZyYW5jaXNjbyB8 ICAxOTk0LTExLTI5ICB8ICA0MyAgfCAgNTcgfCBTYW4gRnJhbmNpc2NvIHwgIDE5OTQtMTEtMjcg IHwgCjQ2IHwgICA1MA0KIEhheXdhcmQgICAgICAgfCAgMTk5NC0xMS0yOSAgfCAgMzcgfCAgIDU0 IHwgU2FuIEZyYW5jaXNjbyB8IDE5OTQtMTEtMjcgfCA0Ngp8ICAgNTANCigyIHJvd3MpDQpgYGAK --===============4511479949613966115==--