Thomas Lockhart <[EMAIL PROTECTED]> 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
- Re: GET DIAGNOSTICS (was Re: [HACKE... Tom Lane
- Re: GET DIAGNOSTICS (was Re: [HACKE... Jan Wieck
- Re: GET DIAGNOSTICS (was Re: [HACKE... Tom Lane
- Re: GET DIAGNOSTICS (was Re: [HACKE... Bruce Momjian
- Re: GET DIAGNOSTICS (was Re: [HACKE... Peter Eisentraut
- Re: GET DIAGNOSTICS (was Re: [HACKE... Tom Lane
- Re: GET DIAGNOSTICS (was Re: [HACKE... Jan Wieck
- Re: GET DIAGNOSTICS (was Re: [HACKE... Jan Wieck
- Re: GET DIAGNOSTICS (was Re: [HACKERS] O... Jan Wieck
- [HACKERS] Re: Open 7.1 items Thomas Lockhart
- [HACKERS] Re: Open 7.1 items Tom Lane
- [HACKERS] Re: Open 7.1 items Thomas Lockhart
- Re: [HACKERS] Open 7.1 items Hannu Krosing
- Re: [HACKERS] Open 7.1 items Bruce Momjian
- Re: [HACKERS] Open 7.1 items Hannu Krosing
- Re: [HACKERS] Open 7.1 items Bruce Momjian
- Re: [HACKERS] Open 7.1 items Vadim Mikheev
- Re: [HACKERS] Open 7.1 items Bruce Momjian
- Re: [HACKERS] Open 7.1 items Manuel Cabido