skip to main content
Part 4: The Connect XE Drivers : The Greenplum Wire Protocol Driver : Greenplum Connection Option Descriptions : Unbounded Numeric Precision
 
Unbounded Numeric Precision
Attribute
UnboundedNumericPrecision (UNP)
Purpose
Specifies the precision 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 precision for the aggregate column.
Valid Values
A positive integer from 1 to 1000
Default
1000
GUI Tab
Advanced tab