On Jun 30, 2005, at 3:54 PM, Steve Tucknott wrote:
> Running the SQL in PSQL, it seems that a FROM clause is
> automatically appended for the missing 'markUp' table - so it does
> that this is intentional. Is there a way to have this 'rejected' as an
> error - ie selecting from a table not included in the query?
Yes, there is/was designed behavior, and there is a way to shut it
off in postgresql.conf. It's still there for backwards compatibility,
but more recent versions display a notice when a FROM clause is added.
test=# select foo.foo_id, bar_name from foo f join bar using (foo_id);
NOTICE: adding missing FROM-clause entry for table "foo"
Here are some references:
Hope this helps.
grzm myrealbox com
In response to
pgsql-novice by date
|Next:||From: Steve Tucknott||Date: 2005-06-30 07:34:03|
|Subject: Re: Aliased table names ...oddity?|
|Previous:||From: Steve Tucknott||Date: 2005-06-30 06:54:57|
|Subject: Aliased table names ...oddity?|