Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

PostgreSQL Data Types - FLOAT

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - FLOAT
Syntax FLOAT[(p)]
Data Floating-point numeric data
Parameters p specifies the precision in binary digits
Range 1E-307 to 1E+308, 1 ⇐ p ⇐ 53
Default p is 53
Storage Size 4 bytes if p ⇐ 24, 8 bytes if p > 24
Special Values The special case-insensitive values 'NaN' (not-a-number), 'Infinity' and '-Infinity' are allowed
Internals if p ⇐ 24, FLOAT is stored as REAL, if p > 24, FLOAT is stored as DOUBLE PRECISION
Standards ANSI SQL

PostgreSQL FLOAT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle FLOAT(p)
SQL Server FLOAT(p)
MySQL FLOAT(p,s)
Sybase ASE FLOAT(p)
Informix FLOAT(p), p is ignored
HP Neoview FLOAT(p)
Ingres FLOAT

Related Data Types in PostgreSQL

Data Types
Integers BIGINT INT SMALLINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point REAL DOUBLE PRECISION

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