Re: The same result for with SPACE and without SPACE

From: mahesh <mahesha_dba(at)yahoo(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, Mohammed Aslam <hmdaslam97(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
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>
Subject: Re: The same result for with SPACE and without SPACE
Date: 2023-06-15 14:11:33
Message-ID: 1726236757.407336.1686838293703@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-advocacy

Kindly remove from from the group..

On Thursday, June 15, 2023 at 08:44:58 AM CDT, Mohammed Aslam <hmdaslam97(at)gmail(dot)com> wrote:

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 OracleDba OracleDba 2023-06-15 14:11:48 is there pgadmin interface with Hashicorp Vault or command line interface to use master password and update password repository
Previous Message Mohammed Aslam 2023-06-15 13:44:33 Re: The same result for with SPACE and without SPACE

Browse pgsql-advocacy by date

  From Date Subject
Next Message Wetmore, Matthew (CTR) 2023-06-15 15:21:56 The same result for with SPACE and without SPACE
Previous Message Mohammed Aslam 2023-06-15 13:44:33 Re: The same result for with SPACE and without SPACE