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.
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера