| From: | Sergio Lob <Sergio_Lob(at)iwaysoftware(dot)com> | 
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org | 
| Subject: | Precision and scale of numeric column reported as value -1 | 
| Date: | 2005-03-23 18:32:54 | 
| Message-ID: | 4241B656.15682C40@iwaysoftware.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
Bug to report - For a numeric in a table defined by:
CREATE TABLE SERG (F01NUM NUMERIC) ;
, the precision and scale reported by ResultSetMetaData.getScale() and
ResultSetMetaData.getPrecision() are value -1
Attached is a simple java program (Repro1.java) that repros the problem.
Before running repro, you must first create the table "SERG" in a
postgreSQL
database and then modify the url, userid and password in the program to
appropriate values. Notice that output from program shows precision =
-1, scale = -1
Please note that the problem occurs for NUMERIC columns whose precision
and scale are not explicitely stated. For example a column defined as
NUMERIC(10,2) returns a correct precision and scale.
Thanks, Sergio Lob
| Attachment | Content-Type | Size | 
|---|---|---|
| Repro1.java | application/x-unknown-content-type-visualcafefile.document | 2.3 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-23 18:36:33 | Re: [GENERAL] contrib module intagg crashing the backend | 
| Previous Message | Tom Lane | 2005-03-23 17:24:06 | Re: BUG #1518: Conversions to (undocumented) SQL year-month and |