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


Value 41.1 which double precision converts to 41.1000000014.

Is that expected?

Thanks.

Reply via email to