The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/tutorial-join.html
Description:
In section "Chapter 2. The SQL Language", there are two "Exercises" for the
learner to try to do.
My note is about the first one. There, the correct answer is the cartesian
product of the sets of all records from the two joined tables.
Now, if the reader knows the solution then all is well and s/he is not
surprised with the output.
Should they have guessed wrong, however, then, chances are, they will not be
able to figure out the "cartesian product" idea from the output they will
see. The reason is that the 'cities' table contains only one record in it.
If there were at least two records in that table then the solving approach
would have been much more expressive. - IMHO...
Thanks for your great job!!
Best regards.