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-09 23:55:07
Message-ID: Pine.BSO.4.56.0407091853250.17806@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:

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

I've modified the cvs version of the driver to return a size for
times and timestamps with timezones.

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

I've modified the cvs version of the driver to return the number of
fractional seconds in time/timezone fields in the getScale() method. I'm
not sure what you are implying about getPrecision here.

Kris Jurka

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-07-10 01:13:06 Re: BUG #1187: Problem in SQL Functions on Composite Types
Previous Message John Gray 2004-07-09 22:29:43 Re: compile error in contrib/xml2

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-07-09 23:58:40 Re: patch: complain obviously about unknown transaction states
Previous Message Kris Jurka 2004-07-09 23:53:11 Re: Error in DatabaseMetaData TableColumn lenght.dec

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-07-10 01:20:57 Re: [PATCH] s_lock support for win32
Previous Message Bruce Momjian 2004-07-09 20:42:18 fix schema ownership on first connection preliminary patch v2

Browse pgsql-sql by date

  From Date Subject
Next Message Pradeepkumar, Pyatalo (IE10) 2004-07-10 06:31:39 Problem in Stored Procedures
Previous Message Verebes Gabor 2004-07-09 15:34:02 Re: Constraint->function dependency and dump in 7.3