Progress
SQL-92
Guide and Reference
Exact Numeric Data Types
See the "Numeric Literals" section for information on specifying values to be stored in numeric columns.
This is the syntax for an exact_numeric_data_type:
TINYINT
Corresponds to an integer value in the range -128 to +127 inclusive.
SMALLINT
Corresponds to an integer value in the range of -32768 to +32767 inclusive.
INTEGER
Corresponds to an integer value in the range of -2 ** 31 to 2 ** 31-1 inclusive.
NUMERIC | NUMBER [ ( precision [ , scale ] ) ]
Corresponds to a number with the given precision (maximum number of digits) and scale (the number of digits to the right of the decimal point). By default,
NUMERIC
columns have a precision of 32 and a scale of 0. IfNUMERIC
columns omit the scale, the default scale is 0.The range of values for a
NUMERIC
type column is-n
to+n
wheren
is the largest number that can be represented with the specified precision and scale. If a value exceeds the precision of aNUMERIC
column, SQL generates an overflow error. If a value exceeds the scale of aNUMERIC
column, SQL rounds the value.EXAMPLE
NUMERIC
type columns cannot specify a negative scale or specify a scale larger than the precision.The following example shows what values can be inserted into a column created with a precision of 3 and scale of 2:
DECIMAL [ ( precision , scale ) ]
Equivalent to type
NUMERIC
.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |