NUMERIC - Fixed-point numbers

You use the data type NUMERIC for columns that can store fixed-point numbers (see section "Numeric values"). Unlike DECIMAL, the internal representation of NUMERIC is more efficient with regard to output to the screen.

---

[{[ dimension ] | ( dimension )}] NUMERIC[( precision [, scale ])]

---

dimension

Unsigned integer between 1 and 255. The column is a multiple column;
dimension indicates the number of column elements.

Any square brackets shown here in italics are special characters, and must be specified in the statement.

dimension omitted:
The column is an atomic column.

precision

Unsigned integer between 1 and 31 that indicates the total number of significant digits.

precision omitted:
precision=1.

scale

Unsigned integer between 0 and precision that indicates the number of digits to the right of the decimal point.

scale omitted:
scale=0.

Range of values for NUMERIC fixed-point columns

A NUMERIC fixed-point column can store fixed-point numbers whose value is 0 or ranges

from 10 - ^scale to 10^scale to 10 ^{precision-scale}-10 ^-scale.

Example

The SERVICE table has three NUMERIC fixed-point columns: service_price NUMERIC(5,0) vat NUMERIC(2,2) inv_num NUMERIC(4,0) The vat column contains fixed-point numbers with two digits to the right of the decimal point and no digits (that are not equal to null) to the left of the decimal point.