DOUBLE PRECISION - Double-precision floating-point numbers

You use the data type DOUBLE PRECISION for columns that can store double-precision floating-point numbers (see section "Numeric values").

---

[{[ dimension ] | ( dimension )}] DOUBLE PRECISION

---

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.

Range of values for DOUBLE PRECISION columns

A DOUBLE PRECISION column can contain floating-point numbers whose value is 0

or ranges from 5.4E ^-79 to 7.2E ⁺⁷⁵.

The precision of DOUBLE PRECISION floating-point numbers is 53 binary digits or approximately 16 decimal digits.

Example

You define a DOUBLE PRECISION column weight as follows:

weight DOUBLE PRECISION