| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | Mike Martin <mmartin(at)vieo(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Wrong column names in ResultSetMetaData |
| Date: | 2004-08-03 00:41:49 |
| Message-ID: | 410EDF4D.6060808@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Kris Jurka wrote:
>
> On Tue, 3 Aug 2004, Oliver Jowett wrote:
>
>
>> RSMD.getColumnLabel() returns the column alias, or maybe something
>>like the column's comment (can you COMMENT ON columns?) later.
>
>
> The spec authors must have had some
> existing implementation to inspire this feature. The argument that
> getColumnLabel and getColumnName should do the exact same thing just seems
> wrong to me.
That wasn't the argument. The column name is just that a good default
label if you have nothing better to hand. If Postgres had a
(hypothetical) column label field associated with each column, for
example, we could return that.
As for existing implementations, a quick google turned this up:
http://publib.boulder.ibm.com/html/as400/v4r5/ic2924/index.htm?info/db2/rbafymst69.htm
which seems to indicate that DB2 has a column display label (via LABEL
ON COLUMN) in addition to column name & column comment.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Martin | 2004-08-03 01:08:53 | Re: Wrong column names in ResultSetMetaData |
| Previous Message | Mike Martin | 2004-08-03 00:32:09 | Re: Wrong column names in ResultSetMetaData |