Ispirer Website
Ispirer Capabilities - PostgreSQL Migration
Free Trial
PostgreSQL Data Types - DOUBLE PRECISION
Versions: PostgreSQL 8.x and 7.x
PostgreSQL - DOUBLE PRECISION | |
---|---|
Syntax | DOUBLE PRECISION |
Data | Floating-point numeric data |
Range | 1E-307 to 1E+308 |
Special Values | The special case-insensitive values 'NaN' (not-a-number), 'Infinity' and '-Infinity' are allowed |
Storage Size | 8 bytes |
Standards | ANSI SQL |
PostgreSQL DOUBLE PRECISION - Equivalents in Other Databases
Database | Data Type and Conversion |
---|---|
Oracle | NUMBER, BINARY_DOUBLE |
SQL Server | DOUBLE PRECISION |
MySQL | DOUBLE, DOUBLE PRECISION |
Sybase ASE | DOUBLE PRECISION |
Informix | DOUBLE PRECISION |
HP Neoview | DOUBLE PRECISION |
Related Data Types in PostgreSQL
Data Types | ||||
---|---|---|---|---|
Integers | BIGINT | INT | SMALLINT | |
Fixed-point | DECIMAL(p,s) | NUMERIC(p,s) | ||
Floating-point | FLOAT(p) | REAL |
All Data Types