Precision and scale of numeric column reported as value -1

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

Responses

Browse pgsql-bugs by date

  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