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:

SYNTAX
{ REAL | DOUBLE PRECISION | FLOAT [ ( precision ) ] } 

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. The REAL data type is same as a FLOAT(4) and double-precision is the same as a FLOAT(8).


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095