Ispirer Website Ispirer Capabilities - Ingress Migration Free Trial

Ingres Data Types - REAL

Versions: Ingres 9.x and 10.0

Ingres - REAL
Syntax REAL
Data 32-bit floating-point numeric data
Parameters 7 digit precision
Range -1.0E+38 to +1.0E+38
Synonyms FLOAT4
Storage Size 4 bytes
Standards ANSI SQL

Ingres REAL - Equivalents in Other Databases

Database Data Type and Conversion
Oracle FLOAT(24); BINARY_FLOAT
SQL Server REAL
MySQL REAL(p,s)
PostgreSQL REAL
Sybase ASE REAL
Informix REAL, SMALLFLOAT
HP Neoview REAL

Related Data Types in Ingres

Data Types
Integers BIGINT INTEGER SMALLINT TINYINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.