Postgres Pro
Downloads
Home   >   mailing lists

Re: CONCAT function adding extra characters - Mailing list pgsql-general

From Tom Lane
Subject Re: CONCAT function adding extra characters
Date
Msg-id 436968.1623784061@sss.pgh.pa.us
Whole thread Raw
In response to CONCAT function adding extra characters  (AI Rumman <rummandba@gmail.com>)
Responses Re: CONCAT function adding extra characters  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
AI Rumman <rummandba@gmail.com> 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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: CONCAT function adding extra characters
Next
From: Kenneth Marshall
Date:
Subject: Re: CONCAT function adding extra characters