| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Dave Cramer <Dave(at)micro-automation(dot)net> |
| Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | RE: select on multiple tables |
| Date: | 2001-08-21 16:25:20 |
| Message-ID: | Pine.LNX.4.30.0108211823290.856-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2001-08-21 16:45:19 | Re: Bad BigDecimal |
| Previous Message | Robert B. Easter | 2001-08-21 16:03:21 | Serialize and object-oriented features |