AI Rumman <rummandba@xxxxxxxxx> writes: > I am using Postgresql 10 and seeing a strange behavior in CONCAT function > when I am concatenating double precision and int with a separator. > select concat('41.1'::double precision,':', 20); >> Result: >> 41.1000000000000014:20 What have you got extra_float_digits set to? regards, tom lane