The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/tutorial-join.html Description:
The example of self join shows two resulting records. I have checked the input data. There are three output records with lower lo and higher high temperatures We seem to be missing, in the answer, a third record: ( (San Francisco, 46, 50) , (Hayward, 54, 37 ))