Postgres Pro
Downloads
Home   >   mailing lists

Re: The same result for with SPACE and without SPACE - Mailing list pgsql-admin

From Scott Ribe
Subject Re: The same result for with SPACE and without SPACE
Date
Msg-id 2CAFD37D-68FC-4A01-BE65-FAF1ADF7A60A@elevated-dev.com
Whole thread Raw
In response to The same result for with SPACE and without SPACE  ("Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com>)
Responses Re: The same result for with SPACE and without SPACE
List pgsql-admin
Tree view 
> On Jun 15, 2023, at 7:08 AM, Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com> wrote:
>
> I can reproduce this with a INT

?

When casting string to integer, trailing spaces do not cause an exception. When casting integer to char(n), the string
willbe blank padded.

pgsql-admin by date:

Previous
From: "Wetmore, Matthew (CTR)"
Date:
Subject: The same result for with SPACE and without SPACE
Next
From: Mohammed Aslam
Date:
Subject: Re: The same result for with SPACE and without SPACE