Re: CONCAT function adding extra characters

Adrian Klaver <adrian.klaver@xxxxxxxxxxx> · Tue, 15 Jun 2021 12:07:30 -0700

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?

Aah, too quick on the trigger.

Also:

Is there a home brewed version of CONCAT() in the search_path?

Thanks.

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx