Natural join of those two tables will be on (gameid, touched)
not only (gameid). You should've noticed that the natural
join was only emitting one copy of the "touched" column ...
regards, tom lane
---(end of broadcast)---
I am seeing different results when using 'natural join' as opposed to
'join ... using' on what I think the equivalent columns should be.
The 'join ... using' version of the query gives the expected answer.
I have tried this on 7.1.3 (built locally) and 7.2b4 with a patch
to how foreign keys are ch
