WingNews logo WingNews
top | item 39264360

(no title)

3rd3 | 2 years 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)

discuss

order

ComputerGuru|2 years ago

For 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|2 years ago

Could you give an example?