3 ms·
What is the point of the cross join? This would work as well: SELECT loop.value, loop.value * loop.value FROM generate_series(1,5) AS loop(value)
by 3rd3 3y ago
What is the point of the cross join? This would work as well:
SELECT loop.value, loop.value * loop.value
FROM generate_series(1,5) AS loop(value)
- ComputerGuru 3y agoFor this example, nothing. It would be useful where neither of the two SELECT queries is a subset/superset of the other. (Not saying you didn't know that.)
- 3rd3 3y agoCould you give an example?
- ako 3y agoThis will be useful if you have a table with some related history records, e.g., products with product price history, and you want to get the latest price. The lateral join would get all prices for the current product, sort them by date and then pick the top row.