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
wrote:
>
>
> út 15. 6. 2021 v 21:07 odesílatel Tom Lane napsal:
>
>> AI Rumman writes:
>> > I am using Postgresql 10 and seeing a strange behavior in C
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.1014:20
Value 41.1 which double
út 15. 6. 2021 v 21:07 odesílatel Tom Lane napsal:
> AI Rumman 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.
> út 15. 6. 2021 v 20:56 odesílatel AI Rumman 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.1014:20
>
>
> Va
AI Rumman 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.1014:20
What have you got extra_float_digits set to?
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.1014:20
Value 41.1 which doubl
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.1014:20
Value 41.1 which doubl
Hi
út 15. 6. 2021 v 20:56 odesílatel AI Rumman 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.1014:20
>
>
>
