Learn about numeric (floating point) datatypes.
<float> – positive or negative floating point numbers. Precision and number of significant digits are machine-dependent. Storage size is 8 bytes.
<real> – like <float> except the storage size is 4 bytes.
Do not include columns using the approximate numeric (floating point) datatypes in the primary key of the replication definition.