I saw that problem when I was running the query from DBeaver. Got my answer.
Thanks & Regards. On Tue, Jun 15, 2021 at 12:18 PM Pavel Stehule <[email protected]> wrote: > > > út 15. 6. 2021 v 21:07 odesílatel Tom Lane <[email protected]> napsal: > >> AI Rumman <[email protected]> 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? >> >> > postgres=# set extra_float_digits to 3; > SET > postgres=# select concat('41.1'::double precision,':', 20); > ┌────────────────────────┐ > │ concat │ > ╞════════════════════════╡ > │ 41.1000000000000014:20 │ > └────────────────────────┘ > (1 row) > > Pavel > > > >> regards, tom lane >> >> >>
