Postgres Pro
Downloads
Home   >   mailing lists

Re: 'natural join' and 'join ... using' giving different results - Mailing list pgsql-bugs

From Tom Lane
Subject Re: 'natural join' and 'join ... using' giving different results
Date
Msg-id 14809.1010607972@sss.pgh.pa.us
Whole thread Raw
In response to 'natural join' and 'join ... using' giving different results  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: case-sensitivity inconsistency in quoted column aliases
Next
From: Stephan Szabo
Date:
Subject: Re: 'natural join' and 'join ... using' giving different