Cross join in Postgres
Introduction The CROSS JOIN, also referred to as the CARTESIAN JOIN, function in Postgres allows for joining each row in one table to all the rows of another table, creating a Cartesian product. A Cartesian Product is a factor of two sets to create a set of all of the ordered pairs with the first … Continued