Re: ResultSerMetaData.getColumnDisplaySize() with timestamp

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ResultSerMetaData.getColumnDisplaySize() with timestamp
Date: 2004-07-08 06:46:25
Message-ID: Pine.BSO.4.56.0407080142490.23659@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc pgsql-patches pgsql-sql

On Wed, 7 Jul 2004, Dario V. Fassi wrote:

> I believe that the method ResultSerMetaData.getColumnDisplaySize()
> with timestamp columns return 0 length
> when they would return 19 or 26.

Yes it appears to only handle timestamp and not timestamp with time zone.
Will fix.

> The same way , methods getColumnPresicion() and getColumnScale() .

I'm not sure what this comment means. I'm guessing you'd like to be able
to tell the difference between timestamp(0) and timestamp(6), but that is
not clear. As I understood it these numbers were really only for numeric
types, but extending that to timestamps does seem useful.

Kris Jurka

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Martin Pitt 2004-07-08 12:54:30 Re: Fwd: Bug#253295: postgresql: VACUUM FULL produce warnings
Previous Message Peter Eisentraut 2004-07-08 05:33:11 Re: Can't join on null values

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-07-08 06:50:26 Re: getXXX methods
Previous Message Kris Jurka 2004-07-08 06:37:27 Re: no link in GBorg

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-07-08 16:48:34 Re: Digital Mars C++ - Clients
Previous Message Andrew Dunstan 2004-07-07 16:04:02 plperl fixes

Browse pgsql-sql by date

  From Date Subject
Next Message Gerwin Philippo 2004-07-08 07:26:15 Re: append columns that are null
Previous Message Hans de Bruin 2004-07-07 19:35:16 Re: append columns that are null