Date: Thu, 15 Jun 2023 14:11:33 +0000 (UTC)
From: mahesh <mahesha_dba@yahoo.com>
Reply-To: mahesh <mahesha_dba@yahoo.com>
To: Scott Ribe <scott_ribe@elevated-dev.com>,
	Mohammed Aslam <hmdaslam97@gmail.com>,
	"pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Cc: "Wetmore, Matthew (CTR)" <matthew.wetmore@express-scripts.com>,
	Tom Lane <tgl@sss.pgh.pa.us>, M Sarwar <sarwarmd02@outlook.com>
Message-ID: <1726236757.407336.1686838293703@mail.yahoo.com>
In-Reply-To: 
 <CAJXhg9ByRV9QPVcW5MPi2c20g948Oxt8qU1DrcVb51fFgTEj2A@mail.gmail.com>
References: 
 <DM4PR19MB5978EB964FA1C7B55FFCB02DD35AA@DM4PR19MB5978.namprd19.prod.outlook.com>
 <DM4PR19MB59782360E0C452810D70CBE8D35AA@DM4PR19MB5978.namprd19.prod.outlook.com>
 <B600CCAA-59E5-4907-8E6D-C645CA24AB1D@elevated-dev.com>
 <DM4PR19MB59784B518F25D2C2292CA3FBD35AA@DM4PR19MB5978.namprd19.prod.outlook.com>
 <2018059.1686782739@sss.pgh.pa.us>
 <0055148e2cc742cbbc23485ae0c6c04e@express-scripts.com>
 <2CAFD37D-68FC-4A01-BE65-FAF1ADF7A60A@elevated-dev.com>
 <CAJXhg9ByRV9QPVcW5MPi2c20g948Oxt8qU1DrcVb51fFgTEj2A@mail.gmail.com>
Subject: Re: The same result for with SPACE and without SPACE
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_407335_1713834487.1686838293702"
Content-Length: 2859
Archived-At: 
 <https://www.postgresql.org/message-id/1726236757.407336.1686838293703%40mail.yahoo.com>
Precedence: bulk

------=_Part_407335_1713834487.1686838293702
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

 Kindly remove from from the group..

    On Thursday, June 15, 2023 at 08:44:58 AM CDT, Mohammed Aslam <hmdaslam97@gmail.com> wrote:  
 
 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.


------=_Part_407335_1713834487.1686838293702
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html><head></head><body><div class="ydpea89c025yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
        <div dir="ltr" data-setdir="false"><span>Kindly remove from from the group..</span><br></div><div><br></div>
        
        </div><div id="yahoo_quoted_7227494705" class="yahoo_quoted">
            <div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
                
                <div>
                    On Thursday, June 15, 2023 at 08:44:58 AM CDT, Mohammed Aslam &lt;hmdaslam97@gmail.com&gt; wrote:
                </div>
                <div><br></div>
                <div><br></div>
                <div><div id="yiv5314738004"><div><div>Kindly remove from here</div><br clear="none"><div id="yiv5314738004yqt41573" class="yiv5314738004yqt1210606211"><div class="yiv5314738004gmail_quote"><div dir="ltr" class="yiv5314738004gmail_attr">On Thu, 15 Jun, 2023, 7:09 pm Scott Ribe, &lt;<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:scott_ribe@elevated-dev.com" target="_blank" href="mailto:scott_ribe@elevated-dev.com">scott_ribe@elevated-dev.com</a>&gt; wrote:<br clear="none"></div><blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;" class="yiv5314738004gmail_quote">&gt; On Jun 15, 2023, at 7:08 AM, Wetmore, Matthew (CTR) &lt;<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:Matthew.Wetmore@express-scripts.com" target="_blank" href="mailto:Matthew.Wetmore@express-scripts.com">Matthew.Wetmore@express-scripts.com</a>&gt; wrote:<br clear="none">
&gt; <br clear="none">
&gt; I can reproduce this with a INT<br clear="none">
<br clear="none">
?<br clear="none">
<br clear="none">
When casting string to integer, trailing spaces do not cause an exception. When casting integer to char(n), the string will be blank padded.<br clear="none">
<br clear="none">
</blockquote></div></div>
</div></div></div>
            </div>
        </div></body></html>
------=_Part_407335_1713834487.1686838293702--