Giacomo G wrote:
> But, when i run the same query with the real name of table in the where
> statement I get this:
This isn't the "real name" of the table "t0". It is another reference to
table "foo", and as such should either raise an error or arrange to
alter the from-clause to make it valid (which is what happens).
> test=# select * from foo t0 join bar t1 on ( t0.a = t1.c ) where foo.a = 1;
> NOTICE: adding missing FROM-clause entry for table "foo"
> a | b | c | d
> 1 | abc | 1 | ghi
> 2 | def | 2 | jkl
> (2 rows)
> while I expect the same result of the first query.
In recent versions, you can disable the feature in your postgresql.conf
by setting "add_missing_from" to false. See the manuals - run-time
environment / compatibility.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2005-07-25 14:58:28|
|Subject: Re: BUG #1784: "adding missing FROM-clause" when not needed |
|Previous:||From: Michael Fuhr||Date: 2005-07-25 14:16:21|
|Subject: Re: BUG #1784: "adding missing FROM-clause" when not needed|