Progress
SQL-92
Guide and Reference
Approximate Numeric Data Types
See the "Numeric Literals" section for details on specifying values to be stored in numeric columns.
This is the syntax for an approximate_numeric_data_type:
REAL
Corresponds to a single precision floating-point number equivalent to the C Language float type.
DOUBLE PRECISION
Corresponds to a double precision floating-point number equivalent to the C Language double type.
FLOAT [ ( precision ) ]
Corresponds to a double precision floating-point number of the given precision, in bytes. By default,
FLOAT
columns have a precision of 8. TheREAL
data type is same as aFLOAT(4)
and double-precision is the same as aFLOAT(8)
.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |