pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Kris Jurka <books@ejurka.com>
To: Dario V. Fassi <software@sistemat.com.ar>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: ResultSerMetaData.getColumnDisplaySize() with timestamp
Date: Thu, 8 Jul 2004 01:46:25 -0500 (EST)
Message-ID: <Pine.BSO.4.56.0407080142490.23659@leary.csoft.net> (raw)
In-Reply-To: <40EB98BD.9060700@sistemat.com.ar>
References: <40E6088E.6030703@yahoo.com.ar>
	<Pine.BSO.4.56.0407030343090.19721@leary.csoft.net>
	<40E6E7AF.5020306@sistemat.com.ar>
	<40E6FD7F.50801@sistemat.com.ar>
	<Pine.BSO.4.56.0407041330180.26773@leary.csoft.net>
	<20040704153840.Y52747@megazone.bigpanda.com>
	<40E89282.9060306@sistemat.com.ar>
	<20040704173258.Y55353@megazone.bigpanda.com>
	<40E8AA9A.7020806@sistemat.com.ar>
	<40EB98BD.9060700@sistemat.com.ar>



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

view thread (3+ messages)  latest in thread

Message-ID: <Pine.BSO.4.56.0407080142490.23659@leary.csoft.net>
Permalink:  ../Pine.BSO.4.56.0407080142490.23659@leary.csoft.net/
Also on:    postgresql.org/message-id/Pine.BSO.4.56.0407080142490.23659@leary.csoft.net

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: books@ejurka.com, software@sistemat.com.ar, pgsql-jdbc@postgresql.org
  Subject: Re: ResultSerMetaData.getColumnDisplaySize() with timestamp
  In-Reply-To: <Pine.BSO.4.56.0407080142490.23659@leary.csoft.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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