Re: Error in DatabaseMetaData TableColumn lenght.dec

On Sat, 10 Jul 2004, Tom Lane wrote:

> Kris Jurka <books@ejurka.com> writes:
> > I've modified the cvs version of the driver to return numeric(1000,1000)
> > which is the maximum precision and scale you are allowed to define.  A
> > more complete solution is outside the realm of the JDBC driver.
>
> That doesn't sound like a usable answer at all.  A client that believes
> this result will think that the value cannot contain any digits to the
> left of the decimal point --- which is certainly not so.

I blew this one.  For some reason I was thinking 1000, 1000 was 1000 to
the left and right of the decimal.

> Does the JDBC spec allow you to return NULL for these entries?  That's
> what we recently fixed the information_schema views to do for
> unconstrained numeric columns.

No, the method returns "int" which is a primitive type and therefore can't
be null.  Maybe -1?  I'm not sure what the best answer is.

Kris Jurka