Re: [BUGS] Precision and scale of numeric column reported as value

[Sergio Lob]

Precision is the number of total digits in the number. Scale is the 
number of  fractional digits.
For instance, a column defined as NUMERIC(10,3)  should return 
precision=10, scale=3. The error only occurs for a column defined as 
NUMERIC  (without precision or scale specified). Presumably, there is a 
default precision and scale assigned to the column by postgreSQL, which 
is not -1.
Sergio

Oliver Jowett wrote:
Sergio Lob wrote:
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

What should they return instead in this case?
-O

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match