Should the cartesian product be more easily seen?

From: mnikulyak(at)gmail(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: Should the cartesian product be more easily seen?
Date: 2017-03-07 20:57:21
Message-ID: 20170307205721.25051.30046@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Browse pgsql-docs by date

  From Date Subject
Next Message aquibmir 2017-03-07 22:16:46 Examples with columns and tables
Previous Message Tom Lane 2017-03-07 01:50:22 Re: EXCLUDE logical wording: "not all" should be "none"