Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: CONCAT function adding extra characters
Date
Msg-id CAFj8pRDb4MevTh5kV7hsXbX9hszCt3Ca8hRrCOdOp9ag5H3HyQ@mail.gmail.com
Whole thread Raw
In response to CONCAT function adding extra characters  (AI Rumman <rummandba@gmail.com>)
Responses Re: CONCAT function adding extra characters
List pgsql-general
Tree view
Hi

út 15. 6. 2021 v 20:56 odesílatel AI Rumman <rummandba@gmail.com> napsal:
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?

this is strange

postgres=# select concat('41.1'::double precision,':', 20);
┌─────────┐
│ concat  │
╞═════════╡
│ 41.1:20 │
└─────────┘
(1 row)

postgres=# select version();
┌───────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│                                                  version                                                  │
╞═══════════════════════════════════════════════════════════════════════════════════════════════════════════╡
│ PostgreSQL 10.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.1.1 20210428 (Red Hat 11.1.1-1), 64-bit │
└───────────────────────────────────────────────────────────────────────────────────────────────────────────┘
(1 row)

Regards

Pavel


Thanks.

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: CONCAT function adding extra characters
Next
From: Adrian Klaver
Date:
Subject: Re: CONCAT function adding extra characters