rsmd.getPrecision(i) + rsmd.isNullable(i)

From: Jens Haberer <gock(at)gmx(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: rsmd.getPrecision(i) + rsmd.isNullable(i)
Date: 2003-05-27 12:30:18
Message-ID: 25218.1054038618@www4.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

i have follwing table:

"s1" bpchar(12)
"s23" numeric(5,2)
"s12" varchar(12)
"s93" timestamptz

when i export the stucture of this table with a java program i get following
results:

name type precision scale nullable (from the resultsetmetadata object)
s1 1 0 0 2
s23 2 5 2 2
s12 12 0 0 2
s93 93 0 0 2

why is precision of "s1" 0?
why is precision of "s12" 0?
why ist nullable always 2? Other databases have 0 or 1!

i tried lot of jdbc driver from http://jdbc.postgresql.org/download/

greetings

jens haberer

--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fernando Nasser 2003-05-27 14:00:06 Re: Bug #926: if old postgresql.jar in CLASSPATH, ant fails
Previous Message Bjorn T Johansen 2003-05-27 10:33:16 WARNING: ROLLBACK: no transaction in progress