numeric type - Mailing list pgsql-jdbc

From Peter
Subject numeric type
Date
Msg-id 005b01c8ea53$f64a9fd0$e2dfdf70$@com
Whole thread Raw
Responses Re: numeric type  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

For numeric types (with no explicit scale and precision) JDBC returns 0 for both precision and scale (ResultSetMetaData.getPrecision and getScale methods). This is breaking my app and IMO does not reflect true state of things since Postgres docs state: „NUMERIC without any precision or scale creates a column in which numeric values of any precision and scale can be stored, up to the implementation limit on precision”.

 

Shouldn’t PG JDBC driver return maximum possible values for precision and scale in such cases?

 

Peter

 

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with java infinity mapping to postgres real column type
Next
From: "Arun ViswanathanChandrika"
Date:
Subject: issue with select IN (?) query