From software@sistemat.com.ar Wed Jul  7 06:24:48 2004
X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 973E4D1B174
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Wed,  7 Jul 2004 03:24:48 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 93243-05
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Wed,  7 Jul 2004 06:23:53 +0000 (GMT)
Received: from mail.svhost.com.ar (mail.svhost.com.ar [200.80.239.22])
	by svr1.postgresql.org (Postfix) with ESMTP id 47F7AD1B1B6
	for <pgsql-jdbc@postgresql.org>; Wed,  7 Jul 2004 03:23:10 -0300 (ADT)
Received: from sistemat.com.ar (devel.sistemat.com.ar [192.168.1.40])
	by mail.svhost.com.ar (Postfix) with ESMTP id 615462C3CA
	for <pgsql-jdbc@postgresql.org>; Wed,  7 Jul 2004 03:21:44 -0300 (ART)
Message-ID: <40EB98BD.9060700@sistemat.com.ar>
Date: Wed, 07 Jul 2004 03:31:25 -0300
From: "Dario V. Fassi" <software@sistemat.com.ar>
Organization: SISTEMATICA ingenieria de software srl
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: es, es-ar, en-us, en
MIME-Version: 1.0
To: pgsql-jdbc@postgresql.org
Subject: ResultSerMetaData.getColumnDisplaySize() with timestamp error
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>
In-Reply-To: <40E8AA9A.7020806@sistemat.com.ar>
Content-Type: multipart/alternative;
	boundary="------------050309070804070006060704"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=2.5 tagged_above=0.0 required=5.0 tests=HTML_30_40,
	HTML_MESSAGE, HTML_TITLE_EMPTY, NO_DNS_FOR_FROM
X-Spam-Level: **
X-Archive-Number: 200407/50
X-Sequence-Number: 10434

This is a multi-part message in MIME format.
--------------050309070804070006060704
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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() .

--------------050309070804070006060704
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<div class="moz-signature">Hi all,<br>
<br>
I believe that the method&nbsp;&nbsp; ResultSerMetaData.<b>getColumnDisplaySize()</b>
with timestamp columns return 0 length <br>
when they would return 19 or 26.<br>
<br>
The same way , methods getColumnPresicion()&nbsp; and getColumnScale() .<br>
</div>
</body>
</html>

--------------050309070804070006060704--




From books@ejurka.com Thu Jul  8 06:46:34 2004
X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 78CBED1B1B7
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Jul 2004 03:46:34 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 55450-03
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Thu,  8 Jul 2004 06:46:34 +0000 (GMT)
Received: from mail63.csoft.net (leary3.csoft.net [63.111.22.74])
	by svr1.postgresql.org (Postfix) with SMTP id 35F39D1B1B6
	for <pgsql-jdbc@postgresql.org>; Thu,  8 Jul 2004 03:46:30 -0300 (ADT)
Received: (qmail 19102 invoked by uid 1112); 8 Jul 2004 06:46:25 -0000
Date: Thu, 8 Jul 2004 01:46:25 -0500 (EST)
From: Kris Jurka <books@ejurka.com>
X-X-Sender: books@leary.csoft.net
To: "Dario V. Fassi" <software@sistemat.com.ar>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: ResultSerMetaData.getColumnDisplaySize() with timestamp
In-Reply-To: <40EB98BD.9060700@sistemat.com.ar>
Message-ID: <Pine.BSO.4.56.0407080142490.23659@leary.csoft.net>
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>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200407/54
X-Sequence-Number: 10438



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



From books@ejurka.com Fri Jul  9 23:55:31 2004
X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id AABDDD1B1B3
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jul 2004 20:55:31 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 65877-04
	for <pgsql-jdbc-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jul 2004 23:55:32 +0000 (GMT)
Received: from mail63.csoft.net (leary3.csoft.net [63.111.22.74])
	by svr1.postgresql.org (Postfix) with SMTP id 81B5ED1B1A0
	for <pgsql-jdbc@postgresql.org>; Fri,  9 Jul 2004 20:55:18 -0300 (ADT)
Received: (qmail 4165 invoked by uid 1112); 9 Jul 2004 23:55:07 -0000
Date: Fri, 9 Jul 2004 18:55:07 -0500 (EST)
From: Kris Jurka <books@ejurka.com>
X-X-Sender: books@leary.csoft.net
To: "Dario V. Fassi" <software@sistemat.com.ar>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: ResultSerMetaData.getColumnDisplaySize() with timestamp
In-Reply-To: <40EB98BD.9060700@sistemat.com.ar>
Message-ID: <Pine.BSO.4.56.0407091853250.17806@leary.csoft.net>
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>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200407/80
X-Sequence-Number: 10464



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