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. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
