skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The PostgreSQL Wire Protocol Driver : Connection Option Descriptions for PostgreSQL Wire Protocol : Unbounded Numeric Scale
 
Unbounded Numeric Scale
Attribute
UnboundedNumericScale (UNS)
Purpose
Specifies the scale for unbounded NUMERIC columns when they are described within the column, parameter, result set, or table metadata. Executing aggregation operations (for example, sum or avg) on bounded NUMERIC columns often results in the server returning the aggregate column as an unbounded NUMERIC column. When this occurs, this option defines the scale for the aggregate column.
Valid Values
A positive integer from 1 to 998
Notes
*The driver returns the scale specified in this option for the affected columns regardless of the number of decimal digits in a value. If a value contains fewer digits to the right of the decimal than the specified scale, the remaining digits are automatically returned as padded 0s. For example, if your scale is set to 6 and your value is 22.22, the value returned is 22.220000.
Default
6
GUI Tab
Advanced tab