Thomas Dudziak wrote:
> However if this is the case, then I don't think your argument given in
> http://archives.postgresql.org/pgsql-jdbc/2004-08/msg00021.php is
> valid, because from what I understand of the ResultSetMetaData, the
> getTableName method returns the name of the column's table, ie. IMO
> the name of the table where the column is defined in. [...]
We disagree :)
In addition to what Kris posted elsewhere in the thread, there is the
compatibility angle: why should we be gratuitously incompatible with
other JDBC drivers?
> So in your example this cannot be 'f' but must be 'footable'. I mean,
> what would I do with 'f' anyway ?
Use it distinguish that particular "footable" from another "footable" in
a self-join.
-O