Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

sqlways/postgresql/data-types/float.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement