Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
>> ...join visibility issue...
> I'm not sure if the "table shape for natural joins issue" has been
> formalized, but afaik it isn't covered in the scoping patch. Tom?
Far as I know, we were OK on that before.
test=# create table a(f1 int, f2 int);
CREATE
test=# create table b(f1 int, f3 int);
CREATE
test=# select * from a natural join b;f1 | f2 | f3
----+----+----
(0 rows)
test=# select * from a join b using(f1);f1 | f2 | f3
----+----+----
(0 rows)
test=# select * from a join b on (a.f1=b.f1);f1 | f2 | f1 | f3
----+----+----+----
(0 rows)
This is per spec, no?
regards, tom lane