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

Jens,

From the javadoc for ResultSetMetadata:

getPrecision: Get the designated column's number of decimal digits.

The javadoc implies that getPrecision is only for numeric datatypes.
What does 'number of decimal digits' mean for a text column?

As for the isNullable() return value, the driver has no way to determine
if the underlying column in the query is nullable or not, so it returns
the proper value in this case which is: 2 (columnNullableUnknown).

thanks,
--Barry

Jens Haberer wrote:
> 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
>