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.