RE: select on multiple tables

Dave Cramer writes:

> Unfortunately id doesn't return A.c and B.c. Try it in psql...
>
> One way to solve this is to fix the backend to return fully qualified
> column names.

The backend is doing the right thing.  In the most general case of a
complex join you don't even know what table a column came from.  If you
have ambiguous names you should be using AS clauses or JOIN syntax.  SQL
actually requires to raise an error if you have duplicate output column
names, IIRC.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter