Postgres Pro
Downloads
Home   >   mailing lists

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

From Mohammed Aslam
Subject Re: The same result for with SPACE and without SPACE
Date
Msg-id CAJXhg9ByRV9QPVcW5MPi2c20g948Oxt8qU1DrcVb51fFgTEj2A@mail.gmail.com
Whole thread Raw
In response to Re: The same result for with SPACE and without SPACE  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: The same result for with SPACE and without SPACE
List pgsql-admin
Tree view
Kindly remove from here

On Thu, 15 Jun, 2023, 7:09 pm Scott Ribe, <scott_ribe@elevated-dev.com> wrote:
> 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 will be blank padded.

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: The same result for with SPACE and without SPACE
Next
From: mahesh
Date:
Subject: Re: The same result for with SPACE and without SPACE