Re: 'natural join' and 'join ... using' giving different results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 'natural join' and 'join ... using' giving different results
Date: 2002-01-09 20:26:12
Message-ID: 14809.1010607972@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2002-01-09 21:13:26 Re: 'natural join' and 'join ... using' giving different
Previous Message Stephan Szabo 2002-01-09 19:55:00 Re: case-sensitivity inconsistency in quoted column aliases