On 6/15/21 11:55 AM, AI Rumman wrote:
> 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?
No.
What OS and version of same?
How was Postgres installed?
>
> Thanks.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com