| 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: | Whole Thread | Raw Message | 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
| 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 |