Re: Aliased table names ...oddity?

On Jun 30, 2005, at 3:54 PM, Steve Tucknott wrote:

> PostgreSQL-7.4.5

<snip />

> Running the SQL in PSQL, it seems that a FROM clause is
> automatically appended for the missing 'markUp' table - so it does
> seem
> 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:
http://www.postgresql.org/docs/7.4/interactive/runtime-config.html
http://sql-info.de/postgresql/postgres-gotchas.html#1_5

Hope this helps.

Michael Glaesemann
grzm myrealbox com