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 1q1tsu-0003Sk-1a for pgsql-docs@arkaria.postgresql.org; Wed, 24 May 2023 19:10:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q1tss-0001QY-NT for pgsql-docs@arkaria.postgresql.org; Wed, 24 May 2023 19:10:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q1tss-0001QH-BI for pgsql-docs@lists.postgresql.org; Wed, 24 May 2023 19:10:54 +0000 Received: from mout-u-107.mailbox.org ([2001:67c:2050:101:465::107]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q1tsn-001ghJ-0G for pgsql-docs@lists.postgresql.org; Wed, 24 May 2023 19:10:52 +0000 Received: from smtp2.mailbox.org (smtp2.mailbox.org [IPv6:2001:67c:2050:b231:465::2]) (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-107.mailbox.org (Postfix) with ESMTPS id 4QRLPB3nbFz9sT3; Wed, 24 May 2023 21:10:38 +0200 (CEST) Date: Wed, 24 May 2023 21:10:37 +0200 (CEST) From: Erik Wienhold To: Atomic_Sheep , pgsql-docs@lists.postgresql.org Message-ID: <2053109544.160895.1684955437950@office.mailbox.org> In-Reply-To: <1667253069.131800.1684935988763@office.mailbox.org> References: <1667253069.131800.1684935988763@office.mailbox.org> Subject: Re: Cross-Product JOIN? MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_160894_422944405.1684955437950" X-Priority: 3 Importance: Normal X-Rspamd-Queue-Id: 4QRLPB3nbFz9sT3 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_160894_422944405.1684955437950 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit > On 24/05/2023 15:46 CEST Erik Wienhold wrote: > > Personally, I think it should read cartesian product because cross product is > an overloaded term and cartesian product is used more often in the documentation > overall. > > But the same page [0] also uses cross product when talking about grouping sets. > > [0] https://www.postgresql.org/docs/15/queries-table-expressions.html Here's a patch that fixes those two places. -- Erik ------=_Part_160894_422944405.1684955437950 Content-Type: text/x-patch; charset=UTF-8; name=0001-Use-Cartesian-product-consistently-in-docs.patch Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=0001-Use-Cartesian-product-consistently-in-docs.patch X-Part-Id: 9f36db080fbe46d89c30119a7b69c59e RnJvbSBiMjNiZDI2N2FjOWM0ZTc5ZWZiNDcyYzA4ZGMzNTczN2JjOGU5Y2E2IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBFcmlrIFdpZW5ob2xkIDxld2llQGV3aWUubmFtZT4KRGF0ZTog V2VkLCAyNCBNYXkgMjAyMyAyMDoyMTo0NyArMDIwMApTdWJqZWN0OiBbUEFUQ0hdIFVzZSBDYXJ0 ZXNpYW4gcHJvZHVjdCBjb25zaXN0ZW50bHkgaW4gZG9jcwoKRml4ZXMgdHdvIHBsYWNlcyBpbiB0 aGUgZG9jcyB0aGF0IHVzZSAiY3Jvc3MgcHJvZHVjdCIgaW5zdGVhZCBvZiB0aGUKbW9yZSBjb21t b24gIkNhcnRlc2lhbiBwcm9kdWN0IiwgdXNlZCB0aHJvdWdob3V0IHRoZSByZXN0IG9mIHRoZSBk b2NzLgpGb3IgdGhlIE5BVFVSQUwgSk9JTiB3aXRob3V0IGNvbW1vbiBjb2x1bW4gbmFtZXMgaXQg aXMgZWFzaWVzdCB0byByZWZlcgp0byBDUk9TUyBKT0lOIHdoaWNoIGlzIGFscmVhZHkgZGVzY3Jp YmVkIGFzIHRoZSBDYXJ0ZXNpYW4gcHJvZHVjdC4KLS0tCiBkb2Mvc3JjL3NnbWwvcXVlcmllcy5z Z21sIHwgNCArKy0tCiAxIGZpbGUgY2hhbmdlZCwgMiBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9u cygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9xdWVyaWVzLnNnbWwgYi9kb2Mvc3JjL3Nn bWwvcXVlcmllcy5zZ21sCmluZGV4IDY5ODZlYzVjOTIuLmE3NWEyNDFkNjIgMTAwNjQ0Ci0tLSBh L2RvYy9zcmMvc2dtbC9xdWVyaWVzLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3F1ZXJpZXMuc2dt bApAQCAtMzkyLDcgKzM5Miw3IEBAIEZST00gPHJlcGxhY2VhYmxlPnRhYmxlX3JlZmVyZW5jZTwv cmVwbGFjZWFibGU+IDxvcHRpb25hbD4sIDxyZXBsYWNlYWJsZT50YWJsZV9yCiAgICAgICAgIGlu cHV0IHRhYmxlcy4gIEFzIHdpdGggPGxpdGVyYWw+VVNJTkc8L2xpdGVyYWw+LCB0aGVzZSBjb2x1 bW5zIGFwcGVhcgogICAgICAgICBvbmx5IG9uY2UgaW4gdGhlIG91dHB1dCB0YWJsZS4gIElmIHRo ZXJlIGFyZSBubyBjb21tb24KICAgICAgICAgY29sdW1uIG5hbWVzLCA8bGl0ZXJhbD5OQVRVUkFM IEpPSU48L2xpdGVyYWw+IGJlaGF2ZXMgbGlrZQotICAgICAgICA8bGl0ZXJhbD5KT0lOIC4uLiBP TiBUUlVFPC9saXRlcmFsPiwgcHJvZHVjaW5nIGEgY3Jvc3MtcHJvZHVjdCBqb2luLgorICAgICAg ICA8bGl0ZXJhbD5DUk9TUyBKT0lOPC9saXRlcmFsPi4KICAgICAgICA8L3BhcmE+CiAKICAgICAg ICA8bm90ZT4KQEAgLTEzNjIsNyArMTM2Miw3IEBAIEdST1VQSU5HIFNFVFMgKAogCiAgICA8cGFy YT4KICAgICBJZiBtdWx0aXBsZSBncm91cGluZyBpdGVtcyBhcmUgc3BlY2lmaWVkIGluIGEgc2lu Z2xlIDxsaXRlcmFsPkdST1VQIEJZPC9saXRlcmFsPgotICAgIGNsYXVzZSwgdGhlbiB0aGUgZmlu YWwgbGlzdCBvZiBncm91cGluZyBzZXRzIGlzIHRoZSBjcm9zcyBwcm9kdWN0IG9mIHRoZQorICAg IGNsYXVzZSwgdGhlbiB0aGUgZmluYWwgbGlzdCBvZiBncm91cGluZyBzZXRzIGlzIHRoZSBDYXJ0 ZXNpYW4gcHJvZHVjdCBvZiB0aGUKICAgICBpbmRpdmlkdWFsIGl0ZW1zLiAgRm9yIGV4YW1wbGU6 CiA8cHJvZ3JhbWxpc3Rpbmc+CiBHUk9VUCBCWSBhLCBDVUJFIChiLCBjKSwgR1JPVVBJTkcgU0VU UyAoKGQpLCAoZSkpCi0tIAoyLjQwLjEKCg== ------=_Part_160894_422944405.1684955437950--