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 1q2KJV-0000fJ-9Y for pgsql-docs@arkaria.postgresql.org; Thu, 25 May 2023 23:24:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q2KJS-0002b6-60 for pgsql-docs@arkaria.postgresql.org; Thu, 25 May 2023 23:24:06 +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 1q2KJR-0002ax-V3 for pgsql-docs@lists.postgresql.org; Thu, 25 May 2023 23:24:05 +0000 Received: from mout-u-204.mailbox.org ([2001:67c:2050:101:465::204]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q2KJO-002Aeu-V3 for pgsql-docs@lists.postgresql.org; Thu, 25 May 2023 23:24:05 +0000 Received: from smtp1.mailbox.org (smtp1.mailbox.org [10.196.197.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-204.mailbox.org (Postfix) with ESMTPS id 4QS3yy0VBNz9sWL; Fri, 26 May 2023 01:23:54 +0200 (CEST) Date: Fri, 26 May 2023 01:23:53 +0200 (CEST) From: Erik Wienhold To: Laurenz Albe , pgsql-docs@lists.postgresql.org Message-ID: <753685717.240313.1685057033384@office.mailbox.org> In-Reply-To: References: <1667253069.131800.1684935988763@office.mailbox.org> <2053109544.160895.1684955437950@office.mailbox.org> <680324ce9104e3d8e9d93b040c152b8bd47b361e.camel@cybertec.at> <1217818053.151381.1684997995236@office.mailbox.org> Subject: Re: Cross-Product JOIN? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 25/05/2023 23:46 CEST Laurenz Albe wrote: > > On Thu, 2023-05-25 at 08:59 +0200, Erik Wienhold wrote: > > > Since we are talking about Cartesian products: is the term "Cartesian join" > > > used anywhere? > > > > Not in the docs: > > I was trying to be funny. The Cartesian product of {Cartesian,cross} and > {product,join} would be {Cartesian product,Cartesian join,cross product,cross join}. And someone beat you to it and apparently planted the joke in the codebase. (Good one, but unfortunately hard to tell apart from a serious question.) -- Erik