CONCAT function adding extra characters
| От | AI Rumman |
|---|---|
| Тема | CONCAT function adding extra characters |
| Дата | |
| Msg-id | CAGoODpdy0zyMbsOCb5n78yM4v2UvWeb2GT9WyCnH1YtSxkcYZA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: CONCAT function adding extra characters
Re: CONCAT function adding extra characters Re: CONCAT function adding extra characters Re: CONCAT function adding extra characters Re: CONCAT function adding extra characters |
| Список | pgsql-general |
I am using Postgresql 10 and seeing a strange behavior in CONCAT function when I am concatenating double precision and int with a separator.
Value 41.1 which double precision converts to 41.1000000014.
Is that expected?
Thanks.
select concat('41.1'::double precision,':', 20);
Result:
41.1000000000000014:20
Value 41.1 which double precision converts to 41.1000000014.
Is that expected?
Thanks.
В списке pgsql-general по дате отправления: