Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dDEkx-0007dF-5y for pgsql-sql@arkaria.postgresql.org; Tue, 23 May 2017 18:42:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dDEkw-0003nq-Ou for pgsql-sql@arkaria.postgresql.org; Tue, 23 May 2017 18:42:06 +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 1dDEjw-0001kp-KK for pgsql-sql@postgresql.org; Tue, 23 May 2017 18:41:04 +0000 Received: from mx3.uci.cu ([200.55.140.180]) by magus.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dDEjq-0004Sa-Eb for pgsql-sql@postgresql.org; Tue, 23 May 2017 18:41:02 +0000 Received: (qmail 27138 invoked from network); 23 May 2017 18:40:52 -0000 Received: from unknown (HELO wmail2.uci.cu) (10.0.0.85) by 0 with SMTP; 23 May 2017 18:40:51 -0000 Received: from localhost (localhost [127.0.0.1]) by wmail2.uci.cu (Postfix) with ESMTP id F25C9D2554D for ; Tue, 23 May 2017 14:32:04 -0400 (CDT) Received: from wmail2.uci.cu ([127.0.0.1]) by localhost (wmail2.uci.cu [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id 19iPmHgPW5I6; Tue, 23 May 2017 14:31:55 -0400 (CDT) Received: from localhost (localhost [127.0.0.1]) by wmail2.uci.cu (Postfix) with ESMTP id 49FF7D255ED for ; Tue, 23 May 2017 14:31:55 -0400 (CDT) X-Amavis-Modified: Mail body modified (using disclaimer) - wmail2.uci.cu X-Virus-Scanned: amavisd-new at wmail2.uci.cu Received: from wmail2.uci.cu ([127.0.0.1]) by localhost (wmail2.uci.cu [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id Jt5dPoT26gIB for ; Tue, 23 May 2017 14:31:55 -0400 (CDT) Received: from ElioCDPC (unknown [10.32.32.252]) (Authenticated sender: ecleger@uci.cu) by wmail2.uci.cu (Postfix) with ESMTPSA id 2DB02D25041 for ; Tue, 23 May 2017 14:31:55 -0400 (CDT) From: "Eliober Cleger Despaigne" To: Subject: about LEFT and INNER JOIN Date: Tue, 23 May 2017 14:38:45 -0400 Message-ID: <012301d2d3f3$cf464bd0$6dd2e370$@uci.cu> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0124_01D2D3D2.4834ABD0" X-Mailer: Microsoft Outlook 15.0 Thread-Index: AdLT8v9ciwkyeX5ARFGTPJVLMK3f5g== Content-Language: es X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 112904 [May 23 2017] X-KLMS-AntiSpam-Version: 5.7.0.14 X-KLMS-AntiSpam-Envelope-From: ecleger@uci.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 225 225 a629c1e82f67f386ae656a77a7e916ac45ce1fd4, {Tracking_Outlook_15}, {Tracking: html bullshit, trash_after_last_tag}, 127.0.0.200:5.2.1;d41d8cd98f00b204e9800998ecf8427e.com:7.1.1;127.0.0.199:7.1.2,5.2.1;uci.cu:7.1.1 X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2017/05/23 14:43:39 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.705, bases: 2017/05/23 13:25:00 #9665661; khse: 2014-01-23 rollback X-KLMS-AntiVirus-Status: Clean, skipped X-Pg-Spam-Score: -0.5 (/) 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 This is a multipart message in MIME format. ------=_NextPart_000_0124_01D2D3D2.4834ABD0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Grettings I need to know which algorithm uses the INNER JOIN and LEFT JOIN. If would be possible, I need to know their costs too in O(n) notation. La @universidad_uci es Fidel. Los jóvenes no fallaremos. #HastaSiempreComandante #HastalaVictoriaSiempre ------=_NextPart_000_0124_01D2D3D2.4834ABD0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Grettings

I need to know which algorithm uses = the INNER JOIN and LEFT JOIN. If would be possible, I need to know their = costs too in O(n) notation.


= =0A=0A
=0ALa @universidad_uci es Fidel. Los jóvenes no fallaremos.=0A#HastaSiempreComandante=0A#HastalaVictoriaSiempre=0A
=0A
=0A=0A=0A
= ------=_NextPart_000_0124_01D2D3D2.4834ABD0--