Re: ODBC - adding missing FROM clause entry

Tambet Matiisen wrote:
>
> This is quite odd feature in PostgreSQL. Try this:
>
> select pg_database.datname from pg_user;
>
> You will get all database names, each repeated by number of
> users and a note:
>
> NOTICE:  Adding missing FROM-clause entry for table "pg_database"
>
> You see, in SELECT you referred a table that is not in FROM
> clause and PostgreSQL is adding it automatically! Seems pretty
> confusing to me, but I didn't dig any further, why is it needed
> or when it this was included.

This feature came from the Berkeley days, so we have had it for a long
time.  In fact, the ODBC code was using it for a few queries which I
just fixed.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073