Re: The same result for with SPACE and without SPACE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Wetmore, Matthew (CTR)" <Matthew.Wetmore@xxxxxxxxxxxxxxxxxxx>
Subject: Re: The same result for with SPACE and without SPACE
From: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Date: Thu, 15 Jun 2023 07:38:36 -0600
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, M Sarwar <sarwarmd02@xxxxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <0055148e2cc742cbbc23485ae0c6c04e@express-scripts.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>

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

Follow-Ups:
- Re: The same result for with SPACE and without SPACE
  - From: Mohammed Aslam

References:
- The same result for with SPACE and without SPACE
  - From: M Sarwar
- Re: The same result for with SPACE and without SPACE
  - From: Scott Ribe
- Re: The same result for with SPACE and without SPACE
  - From: M Sarwar
- Re: The same result for with SPACE and without SPACE
  - From: Tom Lane
- The same result for with SPACE and without SPACE
  - From: Wetmore, Matthew (CTR)

Prev by Date: The same result for with SPACE and without SPACE
Next by Date: Re: The same result for with SPACE and without SPACE
Previous by thread: The same result for with SPACE and without SPACE
Next by thread: Re: The same result for with SPACE and without SPACE
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]