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 1q2Imt-0005OU-U5 for pgsql-docs@arkaria.postgresql.org; Thu, 25 May 2023 21:46:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q2Imq-00077e-Sh for pgsql-docs@arkaria.postgresql.org; Thu, 25 May 2023 21:46:20 +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 1q2Imq-00077V-HU for pgsql-docs@lists.postgresql.org; Thu, 25 May 2023 21:46:20 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q2Iml-0029qe-U6 for pgsql-docs@lists.postgresql.org; Thu, 25 May 2023 21:46:19 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-96f7bf3cf9eso3734966b.0 for ; Thu, 25 May 2023 14:46:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1685051175; x=1687643175; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=n64WtMwFU58T9++dN1EI+LLFPRLFTiUTrl6V7MP29as=; b=swXrZZey7fna0/hZgeYlspxj5fc0TAVULc0iY6V5dtLjAMS5cu1aMiOF/f5hZXNiMS 3I2YtY9SqbOGVSA7cwxfwACjl8M+1d+OWr6iqviS0wti0dKr0nqks96qpEtZwhlIfwSJ XCpSFxdeDG82lemNct6vrOaj2v/DKDqC9QOlia9NSSHPwkRusFwRRNfHGliBIC4fm2ZF 3G53cMylMG3480ymszQRpAJhaf+0nPjtlqbC10PQXmBiudQHgA4jo4Qzh1n6P3ifzX51 75JD5RHinMH6eswwwHELwovajZGhN/HN++sY5tM9hFvKgnPL1QVeCRhla1QfjrPERlbz 31Ow== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685051175; x=1687643175; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=n64WtMwFU58T9++dN1EI+LLFPRLFTiUTrl6V7MP29as=; b=XnzwcTPwz3mNMtcSbdGbM79JQNW+b50koXgXl4NTFSUNfLyJjI9yqHwi5wKp4FwFoD S4/8LiUpgE1xbjFO+6/JCyzXt/qSntktyPujawvcBGn3ImBuf/gFpBQ5hYgv1CPvP3RF YWXOH0/tl6xgSI6Lisjimwxt3RzZJa7bNTFIfT9lXoxWM4NwiwG42I2mNb4orHXpGf8o O8E0dRl2wJe4l60TOX46Wh7TyBlVVv0A1L5uO2Nut41QwkmilwqRd63wmq5l3VSmjEzI QDsgryYhGYpBhyapezdmkEYG8BSP4E/3bS7BY8rYqFztGj9JMt9w6jncUe8Yq+45Hj7l bacA== X-Gm-Message-State: AC+VfDxwLWMD9EHGPC+q+ga3FZaT8IasyQhHTVKauC2Vw8088bhKAJay NHIOLJwz8ETJvobDknnnBABkiVuKkMGxeNHVdVoR4A== X-Google-Smtp-Source: ACHHUZ7hwRI29j7vNjyZj4nUJbz9iqqFh++X8v/TtnTbOL9/GMHo2EVI6x0YdSsgh7NY2DUJ2n6Mmw== X-Received: by 2002:a17:907:9490:b0:96f:9cea:a343 with SMTP id dm16-20020a170907949000b0096f9ceaa343mr177349ejc.17.1685051174582; Thu, 25 May 2023 14:46:14 -0700 (PDT) Received: from localhost.localdomain (dhcp-077-251-249-248.chello.nl. [77.251.249.248]) by smtp.gmail.com with ESMTPSA id cf6-20020a170906b2c600b0096f272206b3sm1307517ejb.125.2023.05.25.14.46.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 25 May 2023 14:46:14 -0700 (PDT) Message-ID: Subject: Re: Cross-Product JOIN? From: Laurenz Albe To: Erik Wienhold , pgsql-docs@lists.postgresql.org Date: Thu, 25 May 2023 23:46:13 +0200 In-Reply-To: <1217818053.151381.1684997995236@office.mailbox.org> References: <1667253069.131800.1684935988763@office.mailbox.org> <2053109544.160895.1684955437950@office.mailbox.org> <680324ce9104e3d8e9d93b040c152b8bd47b361e.camel@cybertec.at> <1217818053.151381.1684997995236@office.mailbox.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-05-25 at 08:59 +0200, Erik Wienhold wrote: > > Since we are talking about Cartesian products: is the term "Cartesian j= oin" > > used anywhere? >=20 > 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,cro= ss join}. Yours, Laurenz Albe