pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ResultSerMetaData.getColumnDisplaySize() with timestamp error
3+ messages / 2 participants
[nested] [flat]

* ResultSerMetaData.getColumnDisplaySize() with timestamp error
@ 2004-07-07 06:31  Dario V. Fassi <software@sistemat.com.ar>
  0 siblings, 2 replies; 3+ messages in thread

From: Dario V. Fassi @ 2004-07-07 06:31 UTC (permalink / raw)
  To: pgsql-jdbc@postgresql.org

Hi all,

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

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ResultSerMetaData.getColumnDisplaySize() with timestamp
@ 2004-07-08 06:46  Kris Jurka <books@ejurka.com>
  parent: Dario V. Fassi <software@sistemat.com.ar>
  1 sibling, 0 replies; 3+ messages in thread

From: Kris Jurka @ 2004-07-08 06:46 UTC (permalink / raw)
  To: Dario V. Fassi <software@sistemat.com.ar>; +Cc: pgsql-jdbc@postgresql.org



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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ResultSerMetaData.getColumnDisplaySize() with timestamp
@ 2004-07-09 23:55  Kris Jurka <books@ejurka.com>
  parent: Dario V. Fassi <software@sistemat.com.ar>
  1 sibling, 0 replies; 3+ messages in thread

From: Kris Jurka @ 2004-07-09 23:55 UTC (permalink / raw)
  To: Dario V. Fassi <software@sistemat.com.ar>; +Cc: pgsql-jdbc@postgresql.org



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
 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-07-09 23:55 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-07 06:31 ResultSerMetaData.getColumnDisplaySize() with timestamp error Dario V. Fassi <software@sistemat.com.ar>
2004-07-08 06:46 ` Re: ResultSerMetaData.getColumnDisplaySize() with timestamp Kris Jurka <books@ejurka.com>
2004-07-09 23:55 ` Re: ResultSerMetaData.getColumnDisplaySize() with timestamp Kris Jurka <books@ejurka.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox