Re: The same result for with SPACE and without SPACE

From: Mohammed Aslam <hmdaslam97(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: "Wetmore, Matthew (CTR)" <Matthew(dot)Wetmore(at)express-scripts(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, M Sarwar <sarwarmd02(at)outlook(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: The same result for with SPACE and without SPACE
Date: 2023-06-15 13:44:33
Message-ID: CAJXhg9ByRV9QPVcW5MPi2c20g948Oxt8qU1DrcVb51fFgTEj2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-advocacy

Kindly remove from here

On Thu, 15 Jun, 2023, 7:09 pm Scott Ribe, <scott_ribe(at)elevated-dev(dot)com>
wrote:

> > On Jun 15, 2023, at 7:08 AM, Wetmore, Matthew (CTR) <
> Matthew(dot)Wetmore(at)express-scripts(dot)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.
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mahesh 2023-06-15 14:11:33 Re: The same result for with SPACE and without SPACE
Previous Message Scott Ribe 2023-06-15 13:38:36 Re: The same result for with SPACE and without SPACE

Browse pgsql-advocacy by date

  From Date Subject
Next Message mahesh 2023-06-15 14:11:33 Re: The same result for with SPACE and without SPACE
Previous Message Scott Ribe 2023-06-15 13:38:36 Re: The same result for with SPACE and without SPACE