numeric type

From: "Peter" <peter(at)greatnowhere(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: numeric type
Date: 2008-07-20 10:32:51
Message-ID: 005b01c8ea53$f64a9fd0$e2dfdf70$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Arun ViswanathanChandrika 2008-07-20 13:39:28 issue with select IN (?) query
Previous Message Tom Lane 2008-07-19 00:51:14 Re: Problem with java infinity mapping to postgres real column type