Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group