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

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!