Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k4k8R-0001OV-3g for pgsql-sql@arkaria.postgresql.org; Sun, 09 Aug 2020 12:09:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k4k8O-0001Yr-TG for pgsql-sql@arkaria.postgresql.org; Sun, 09 Aug 2020 12:09:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k4k8O-0001Yk-Jf for pgsql-sql@lists.postgresql.org; Sun, 09 Aug 2020 12:09:04 +0000 Received: from forward500p.mail.yandex.net ([2a02:6b8:0:1472:2741:0:8b7:110]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k4k8L-0005QF-Lu for pgsql-sql@lists.postgresql.org; Sun, 09 Aug 2020 12:09:04 +0000 Received: from mxback24g.mail.yandex.net (mxback24g.mail.yandex.net [IPv6:2a02:6b8:0:1472:2741:0:8b7:324]) by forward500p.mail.yandex.net (Yandex) with ESMTP id 800D7940017; Sun, 9 Aug 2020 15:08:58 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback24g.mail.yandex.net (mxback/Yandex) with ESMTP id 4Fsx5SDh0K-8vV8qFpI; Sun, 09 Aug 2020 15:08:57 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1596974937; bh=U8F3OalN+ks2UvmnUxZeJRlk0b1wDFnutstGYHCZMNE=; h=References:Date:Message-Id:Subject:In-Reply-To:To:From; b=CgLIG+VAWqPAz9iOIV0Ou0Mc1JXW+WE6TEjgdOMtAUJlj6/jvxp6825Pn3TvG8faK GbzbVfncbfFjhq9vHjO7qMZmRkHgQd0RYx9+E6ora4tuhpWfahu22LzCKa6zxYF2H8 pMHhVYBYS9oUOjN8P+AVl56GQx99mchqRg7VZ/hI= Authentication-Results: mxback24g.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by iva5-4e96f110c519.qloud-c.yandex.net with HTTP; Sun, 09 Aug 2020 15:08:57 +0300 From: Samed YILDIRIM To: "ml@ft-c.de" , "pgsql-sql@lists.postgresql.org" In-Reply-To: <65f26434-b2ed-7fc2-a5ad-e0365e657d5a@ft-c.de> References: <29781596968237@mail.yandex.com.tr> <65f26434-b2ed-7fc2-a5ad-e0365e657d5a@ft-c.de> Subject: Re: recursive sql MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Sun, 09 Aug 2020 15:08:57 +0300 Message-Id: <187651596974558@mail.yandex.com.tr> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IaSBGcmFuayw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5JdCBzZWVtcyBJIG5lZWQgdG8g cmVhZCBtb3JlIGNhcmVmdWxseSA6KTwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PldpdGggd2luZG93 IGZ1bmN0aW9uczs8L2Rpdj48ZGl2PjxkaXY+PGRpdj5wZ3NxbC1zcWw9IyBzZWxlY3QgKixzdW0o Yykgb3ZlciAob3JkZXIgYnkgdHMpIGZyb20gdHQ7PC9kaXY+PGRpdj50cyB8IGMgfCBzdW08L2Rp dj48ZGl2Pi0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0rLS0tLS08L2Rpdj48ZGl2PjIwMTktMTIt MzEgMDA6MDA6MDAgfCAxIHwgMTwvZGl2PjxkaXY+MjAyMC0wMS0wMSAwMDowMDowMCB8IDIgfCAz PC9kaXY+PGRpdj4yMDIwLTA3LTAyIDAwOjAwOjAwIHwgMyB8IDY8L2Rpdj48ZGl2PjIwMjAtMDct MDYgMDA6MDA6MDAgfCA0IHwgMTA8L2Rpdj48ZGl2PjIwMjAtMDctMDcgMDA6MDA6MDAgfCA1IHwg MTU8L2Rpdj48ZGl2PjIwMjAtMDctMDggMDA6MDA6MDAgfCA2IHwgMjE8L2Rpdj48ZGl2Pig2IHJv d3MpPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+PGJyIC8+V2l0aCByZWN1cnNpdmUgcXVlcnk6PC9k aXY+PC9kaXY+PGRpdj48ZGl2PnBnc3FsLXNxbD0jIHdpdGggcmVjdXJzaXZlIHJjIGFzICg8L2Rp dj48ZGl2PnNlbGVjdCAqIGZyb20gKHNlbGVjdCB0cyxjLGMgYXMgYzIgZnJvbSB0dCBvcmRlciBi eSB0cyBhc2MgbGltaXQgMSkgc3ExPC9kaXY+PGRpdj51bmlvbjwvZGl2PjxkaXY+c2VsZWN0ICog ZnJvbSAoc2VsZWN0IHR0LnRzLHR0LmMsdHQuYytyYy5jMiBhcyBjMiBmcm9tIHR0LCBsYXRlcmFs IChzZWxlY3QgKiBmcm9tIHJjIG9yZGVyIGJ5IHRzIGRlc2MgbGltaXQgMSkgcmMgd2hlcmUgdHQu dHMgJmd0OyByYy50cyBvcmRlciBieSB0dC50cyBhc2MgbGltaXQgMSkgc3EyPC9kaXY+PGRpdj4p PC9kaXY+PGRpdj5zZWxlY3QgKiBmcm9tIHJjOzwvZGl2PjxkaXY+dHMgfCBjIHwgYzI8L2Rpdj48 ZGl2Pi0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0rLS0tLTwvZGl2PjxkaXY+MjAxOS0xMi0zMSAw MDowMDowMCB8IDEgfCAxPC9kaXY+PGRpdj4yMDIwLTAxLTAxIDAwOjAwOjAwIHwgMiB8IDM8L2Rp dj48ZGl2PjIwMjAtMDctMDIgMDA6MDA6MDAgfCAzIHwgNjwvZGl2PjxkaXY+MjAyMC0wNy0wNiAw MDowMDowMCB8IDQgfCAxMDwvZGl2PjxkaXY+MjAyMC0wNy0wNyAwMDowMDowMCB8IDUgfCAxNTwv ZGl2PjxkaXY+MjAyMC0wNy0wOCAwMDowMDowMCB8IDYgfCAyMTwvZGl2PjxkaXY+KDYgcm93cyk8 L2Rpdj48L2Rpdj48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5CZXN0IHJlZ2FyZHMuPC9kaXY+PGRp dj5TYW1lZCBZSUxESVJJTTwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwv ZGl2PjxkaXY+MDkuMDguMjAyMCwgMTQ6NTcsICJtbEBmdC1jLmRlIiAmbHQ7bWxAZnQtYy5kZSZn dDs6PC9kaXY+PGJsb2NrcXVvdGU+PHA+SGFsbG8sPGJyIC8+PGJyIC8+d2l0aCB0aGUgd2luZG93 IGZ1bmN0aW9uIGxhZyB0aGVyZSBpcyBhIHNoaWZ0IG9mIG9uZSBvciBtb3JlIHJvd3MuIEV2ZXJ5 PGJyIC8+cm93IGNvbm5lY3RzIHRvIHRoZSBwcmV2aW91cyByb3cgOj0gbGFnKGNvbHVtbiwxKS48 YnIgLz48YnIgLz5XaGF0IEkgYW0gbG9va2luZyBmb3I6PGJyIC8+dHMgYyBjMjxiciAvPi4uIDEg MSAtLSBvciBudWxsIGluIHRoZSBmaXJzdCByb3c8YnIgLz4uLiAyIDMgLS0gaXQgaXMgdGhlIHJl c3VsdCBvZiAxICsgMjxiciAvPi4uIDMgNiAtLSBpdCBpcyB0aGUgcmVzdWx0IG9mIDMgKyAzPGJy IC8+Li4gNCAxMCAtLSBpdCBpcyB0aGUgcmVzdWx0IG9mIDYgKyA0PGJyIC8+PGJyIC8+PGJyIC8+ RnJhbno8YnIgLz48YnIgLz5PbiA4LzkvMjAgMTI6MzggUE0sIFNhbWVkIFlJTERJUklNIHdyb3Rl OjwvcD48YmxvY2txdW90ZT7CoEhpIEZyYW56LDxiciAvPsKgU2ltcGx5IHlvdSBjYW4gdXNlIHdp bmRvdyBmdW5jdGlvbnNbMV1bMl0uPGJyIC8+wqBwZ3NxbC1zcWw9IyBzZWxlY3QgKiwgbGFnKGMp IG92ZXIgKG9yZGVyIGJ5IHRzKSBhcyBjMiBmcm9tIHR0OzxiciAvPsKgdHMgfCBjIHwgYzI8YnIg Lz7CoC0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0rLS0tLTxiciAvPsKgMjAxOS0xMi0zMSAwMDow MDowMCB8IDEgfDxiciAvPsKgMjAyMC0wMS0wMSAwMDowMDowMCB8IDIgfCAxPGJyIC8+wqAyMDIw LTA3LTAyIDAwOjAwOjAwIHwgMyB8IDI8YnIgLz7CoDIwMjAtMDctMDYgMDA6MDA6MDAgfCA0IHwg MzxiciAvPsKgMjAyMC0wNy0wNyAwMDowMDowMCB8IDUgfCA0PGJyIC8+wqAyMDIwLTA3LTA4IDAw OjAwOjAwIHwgNiB8IDU8YnIgLz7CoCg2IHJvd3MpPGJyIC8+wqBJIHBlcnNvbmFsbHkgcHJlZmVy IHRvIHVzZSB3aW5kb3cgZnVuY3Rpb25zIGR1ZSB0byB0aGVpciBzaW1wbGljaXR5LiBJZjxiciAv PsKgeW91IHN0aWxsIHdhbnQgdG8gdXNlIHJlY3Vyc2l2ZSBxdWVyeTogWzNdPGJyIC8+wqBwZ3Nx bC1zcWw9IyB3aXRoIHJlY3Vyc2l2ZSByYyBhcyAoPGJyIC8+wqBzZWxlY3QgKiBmcm9tIChzZWxl Y3QgdHMsYyxudWxsOjpudW1lcmljIGFzIGMyIGZyb20gdHQgb3JkZXIgYnkgdHMgYXNjPGJyIC8+ wqBsaW1pdCAxKSBrMTxiciAvPsKgdW5pb248YnIgLz7CoHNlbGVjdCAqIGZyb20gKHNlbGVjdCB0 dC50cyx0dC5jLHJjLmMgYXMgYzIgZnJvbSB0dCwgbGF0ZXJhbCAoc2VsZWN0ICo8YnIgLz7CoGZy b20gcmMpIHJjIHdoZXJlIHR0LnRzICZndDsgcmMudHMgb3JkZXIgYnkgdHQudHMgYXNjIGxpbWl0 IDEpIGsyPGJyIC8+wqApPGJyIC8+wqBzZWxlY3QgKiBmcm9tIHJjOzxiciAvPsKgdHMgfCBjIHwg YzI8YnIgLz7CoC0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0rLS0tLTxiciAvPsKgMjAxOS0xMi0z MSAwMDowMDowMCB8IDEgfDxiciAvPsKgMjAyMC0wMS0wMSAwMDowMDowMCB8IDIgfCAxPGJyIC8+ wqAyMDIwLTA3LTAyIDAwOjAwOjAwIHwgMyB8IDI8YnIgLz7CoDIwMjAtMDctMDYgMDA6MDA6MDAg fCA0IHwgMzxiciAvPsKgMjAyMC0wNy0wNyAwMDowMDowMCB8IDUgfCA0PGJyIC8+wqAyMDIwLTA3 LTA4IDAwOjAwOjAwIHwgNiB8IDU8YnIgLz7CoCg2IHJvd3MpPGJyIC8+wqBbMV06IDxhIGhyZWY9 Imh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTIvZnVuY3Rpb25zLXdpbmRvdy5odG1s Ij5odHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzEyL2Z1bmN0aW9ucy13aW5kb3cuaHRt bDwvYT48YnIgLz7CoFsyXTogPGEgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy8xMi90dXRvcmlhbC13aW5kb3cuaHRtbCI+aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy8xMi90dXRvcmlhbC13aW5kb3cuaHRtbDwvYT48YnIgLz7CoFszXTogPGEgaHJlZj0iaHR0cHM6 Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9xdWVyaWVzLXdpdGguaHRtbCI+aHR0cHM6Ly93 d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9xdWVyaWVzLXdpdGguaHRtbDwvYT48YnIgLz7CoEJl c3QgcmVnYXJkcy48YnIgLz7CoFNhbWVkIFlJTERJUklNPGJyIC8+wqAwOS4wOC4yMDIwLCAwOToy OSwgIjxhIGhyZWY9Im1haWx0bzptbEBmdC1jLmRlIj5tbEBmdC1jLmRlPC9hPiIgJmx0OzxhIGhy ZWY9Im1haWx0bzptbEBmdC1jLmRlIj5tbEBmdC1jLmRlPC9hPiZndDs6PGJyIC8+wqA8YnIgLz7C oMKgwqDCoMKgSGVsbG8sPGJyIC8+wqA8YnIgLz7CoMKgwqDCoMKgdGhlIHRhYmxlPGJyIC8+wqDC oMKgwqDCoGNyZWF0ZSB0YWJsZSB0dCAoPGJyIC8+wqDCoMKgwqDCoMKgwqDCoMKgdHMgdGltZXN0 YW1wLDxiciAvPsKgwqDCoMKgwqDCoMKgwqDCoGMgbnVtZXJpYykgOzxiciAvPsKgPGJyIC8+wqDC oMKgwqDCoGluc2VydCBpbnRvIHR0IHZhbHVlczxiciAvPsKgwqDCoMKgwqDCoMKgwqAoJzIwMTkt MTItMzEnLDEpLCAoJzIwMjAtMDEtMDEnLDIpLDxiciAvPsKgwqDCoMKgwqDCoMKgwqAoJzIwMjAt MDctMDInLDMpLCAoJzIwMjAtMDctMDYnLDQpLDxiciAvPsKgwqDCoMKgwqDCoMKgwqAoJzIwMjAt MDctMDcnLDUpLCAoJzIwMjAtMDctMDgnLDYpOzxiciAvPsKgPGJyIC8+wqDCoMKgwqDCoE15IHF1 ZXN0aW9uOiBJdCBpcyBwb3NzaWJsZSB0byBnZXQgYW48YnIgLz7CoMKgwqDCoMKgwqDCoMKgwqBh ZGRpdGlvbmFsIGNvbHVtbiAobmFtZWQgYzIpPGJyIC8+wqDCoMKgwqDCoMKgwqDCoMKgd2l0aDxi ciAvPsKgwqDCoMKgwqDCoMKgwqDCoCggYyBmcm9tIGN1cnJlbnQgcm93ICkgKyAoIGMyIGZyb20g dGhlIHByZXZpb3VzIHJvdyApIGFzIGMyPGJyIC8+wqA8YnIgLz7CoMKgwqDCoMKgdGhlIHJlc3Vs dDo8YnIgLz7CoMKgwqDCoMKgdHMgYyBjMjxiciAvPsKgwqDCoMKgwqAuLiAxIDEgLS0gb3IgbnVs bCBpbiB0aGUgZmlyc3Qgcm93PGJyIC8+wqDCoMKgwqDCoC4uIDIgMzxiciAvPsKgwqDCoMKgwqAu LiAzIDY8YnIgLz7CoMKgwqDCoMKgLi4gNCAxMDxiciAvPsKgwqDCoMKgwqAuLi48YnIgLz7CoDxi ciAvPsKgwqDCoMKgwqB3aXRoIHJlY3Vyc2l2ZSBlbWEgYXMgKCk8YnIgLz7CoMKgwqDCoMKgc2Vs ZWN0IHRzLCBjLDxiciAvPsKgwqDCoMKgwqDCoMKgwqDCoC0tIG1hbnkgbWFueSBjb21wdXRlZF9y b3dzPGJyIC8+wqDCoMKgwqDCoMKgwqDCoMKgLS0gJmx0O2NvZGUmZ3Q7IGFzIGMyPGJyIC8+wqDC oMKgwqDCoGZyb20gdHQgLS0gJmx0Oy0gSSBuZWVkIHR0IG9uIHRoaXMgcGxhY2U8YnIgLz7CoDxi ciAvPsKgPGJyIC8+wqDCoMKgwqDCoHRoYW5rIHlvdSBmb3IgaGVscDxiciAvPsKgwqDCoMKgwqBG cmFuejxiciAvPsKgPC9ibG9ja3F1b3RlPjxwPjxiciAvPsKgPC9wPjwvYmxvY2txdW90ZT4=