Re: [BUGS] 'natural join' and 'join ... using' giving different

2002-01-09 Thread Stephan Szabo
On Wed, 9 Jan 2002, Bruno Wolff III wrote: > 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 local

Re: [BUGS] 'natural join' and 'join ... using' giving different results

2002-01-09 Thread Tom Lane
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)---

[BUGS] 'natural join' and 'join ... using' giving different results

2002-01-09 Thread Bruno Wolff III
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