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

Re: BUG #1784: "adding missing FROM-clause" when not needed

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Giacomo G <matic999(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1784: "adding missing FROM-clause" when not needed
Date: 2005-07-25 14:16:21
Message-ID: 20050725141620.GA35208@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, Jul 25, 2005 at 03:03:54AM +0100, Giacomo G wrote:
> But, when i run the same query with the real name of table in the where
> statement I get this:
> 
> 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"

See the SELECT documentation:

http://www.postgresql.org/docs/8.0/static/sql-select.html

"When an alias is provided, it completely hides the actual name of
the table or function; for example given FROM foo AS f, the remainder
of the SELECT must refer to this FROM item as f not foo."

If you disable add_missing_from then you'll get an error instead
of a notice and unexpected results.  Add_missing_from will be
disabled by default in PostgreSQL 8.1.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

pgsql-bugs by date

Next:From: Richard HuxtonDate: 2005-07-25 14:22:41
Subject: Re: BUG #1784: "adding missing FROM-clause" when not needed
Previous:From: K.G.SivaramanDate: 2005-07-25 11:36:43
Subject: BUG #1785: Return code !!!

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