rsmd.getPrecision(i) + rsmd.isNullable(i) - Mailing list pgsql-jdbc

From Jens Haberer
Subject rsmd.getPrecision(i) + rsmd.isNullable(i)
Date
Msg-id 25218.1054038618@www4.gmx.net
Whole thread Raw
Responses Re: rsmd.getPrecision(i) + rsmd.isNullable(i)  (Barry Lind <blind@xythos.com>)
List 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!


pgsql-jdbc by date:

Previous
From: Rupa Schomaker
Date:
Subject: Re: WARNING: ROLLBACK: no transaction in progress
Next
From: "dean walliss"
Date:
Subject: Bad External Date Representation error for any date which is a Saturday.