Range of Real and Double Precision
real
4 bytes
precision of 8 significant digits
double precision
8 bytes
precision of 17 significant digits
2.222222E12::real
2.22222 × 10
12
All digits significant.
2.2222222E12::real;
2.2222222 × 10
12
One digit dropped.
Date and Timestamp Operators
date - date ➔ integer
timestamptz - timestamptz ➔ interval
date + integer ➔ date
date + interval ➔ timestamp *
timestamptz + interval ➔ timestamptz *
* Avoid year, month and other imprecise units.