Re: CONCAT function adding extra characters

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 6/15/21 1:55 PM, 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?

    Because of the well-known difficulty in precisely converting
    floating point to decimal, in cases like this, I always cast to
    NUMERIC of the desired precision.  It's the COBOL programmer in
    me...

--
Angular momentum makes the world go 'round.