Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q9qXE-0006O9-Ma for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jun 2023 17:13:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9qXC-0000Qs-9Q for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jun 2023 17:13:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q9qXB-0000QL-6z for pgsql-admin@lists.postgresql.org; Thu, 15 Jun 2023 17:13:21 +0000 Received: from mail-sn1nam02olkn2081a.outbound.protection.outlook.com ([2a01:111:f400:7ea9::81a] helo=NAM02-SN1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q9qX3-002Nsf-A2 for pgsql-admin@lists.postgresql.org; Thu, 15 Jun 2023 17:13:19 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=HlvTjxZroW4h5Joa7ZboS93FyUtMkfc8y2yAb5xE0b2ECEZNggN76Dp+Cah+fEFffWPqjJnFmm1OO3gD0ETM70XBu9tkXmGbbQSymO+0hzHUeS6375CB3iIVbp6xmXQd9WcntAdFS5UsZt+IJaLeUTpJ1/UPs6zD7T2BpZPl6fIB9ISx429UNIkvbs9EQVXVIAhaq58+0frkv+MpA9OXuEcPYrVuCM10cgtmSuGm+9l6L0zxGXdJFfxVmO1bVSHwYHQGAcV7vshhR4MOW/mSIQUV3ipTYaWN0kxFsLfeJnfhpQJiC9eghurBL9/53QWwP2uatCAqXURYJab6NM7e2w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=6Q52IRCqysv4aCpfAgNxMtpeaMbRb7uUKH7+MNirWIE=; b=MFWxDuEJu4ZpX4X98fE3LBmqnSPcKJ90BihquLMe56PNswbhEmEbtcowjfvh8heXWGjMHflIez7jLQ73m7G6xyH+BocOUPMi1ydFYQ1skXmfLLJggnI1LejSSpoerSg/ti343zEzv3O/bT9nrphzPI4NUksdcrKg/JMIUDylgLzVN+6Pyy8Xt6aE4oN6wmuxkYEWXyU6u5NxZxSbPfRyKjvn6GIiifejuWZw68yBwiXU6Z1VQLfD8lW2vGT+xdqfrkqi6qcVSRvNm5ReBTRGtBt9V8txtxsUUk4mwgYXGeAlEMGjdVAn+3oMoODiWOYIoIDjTEro/WQ+km0WBiRmZQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=6Q52IRCqysv4aCpfAgNxMtpeaMbRb7uUKH7+MNirWIE=; b=Cf5XfVbDgDyiSduF0MjRHfOd+R3fuQvoeTEjpa7QzqJq26R1/uu1ctie2lylAAYvi5p1pRMNV0fUwCzy/4USjsMSpyN3hzgdG/VlObaceLkCOm1NeHLX2IDhKmySRuZJ6OfaibG7N+ugZnKMV7UvBOUWZI8by//arAQH2UaSUp4HunLNJvbT0ZXpSvljFCetnwicy1OnAbBjphGOjtGH6MKu8hfhRNpFYMMopmgB5aUaXy0eB3rmmu1RQhhZFFgoSbhQjd7EXkjzriq15amBi68SBca3LVM48wEVNqTWg0xYzisgGF0PQm7J2evN+cRW31vo0Rxhtv/TpsBJvRrDcg== Received: from DM4PR19MB5978.namprd19.prod.outlook.com (2603:10b6:8:6a::18) by CO6PR19MB4754.namprd19.prod.outlook.com (2603:10b6:5:348::23) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6521.10; Thu, 15 Jun 2023 17:13:10 +0000 Received: from DM4PR19MB5978.namprd19.prod.outlook.com ([fe80::47d8:cd2d:fe7b:ac1a]) by DM4PR19MB5978.namprd19.prod.outlook.com ([fe80::47d8:cd2d:fe7b:ac1a%3]) with mapi id 15.20.6500.026; Thu, 15 Jun 2023 17:13:10 +0000 From: M Sarwar To: Tom Lane , Scott Ribe CC: "pgsql-admin@lists.postgresql.org" Subject: Re: The same result for with SPACE and without SPACE Thread-Topic: The same result for with SPACE and without SPACE Thread-Index: AQHZnwJ9vgb1T+k9ckKN/se5g26vCa+K1kAmgAAH8ICAAANa0IAABFKAgAE1A3E= Date: Thu, 15 Jun 2023 17:13:10 +0000 Message-ID: References: <2018059.1686782739@sss.pgh.pa.us> In-Reply-To: <2018059.1686782739@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-Mentions: tgl@sss.pgh.pa.us,scott_ribe@elevated-dev.com X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [exP8h7lOH+l9nOS5Ni3Eo478sIHov5XsmWdaVJ327krlosCuORrfkQ==] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DM4PR19MB5978:EE_|CO6PR19MB4754:EE_ x-ms-office365-filtering-correlation-id: 0ea68699-9bc8-4482-91d9-08db6dc3cb85 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: Ie+A1d3cVrDZ0f/52SlS/E1I5vK5J5XMSCb72kch4FNo/Qync8nAneWZe2FwGKgHSuRRTqWpfTl7hZnCBea+XFhXzbVQ1a5LTYSUOk5puVemNXjVhxSKeIX+VZiRjQxRswNVVeQsPQ7F+7EY700bnSyKibPPBVPKkUQBHkWggJgdWuOR8Bsh7UXS8+/z/Tuxno4vZ1yuPZgDVV/Bj/SRzs2iPfvGaHDOITCW4Xv8uHg4oZtE51PxdBu/sPtadB35Eh2gq61twrd7loB9xorHC6XpmThRDWfkpC5WZxRB4HsPMOD/9ZFmdSbsE5VkDQOCVkUpdGMi3d6tf9NyqkFqKMlbUQ8G3S6X6pOcBDKrEaE9lJKrax8OetzT7ulWP4DxrwCyLe1jynj7AnvG7iBOhanlmO0z5uVr2fYF8kdECUDhXle5m2p5QYG8HiwGGAV47YZRo0wTR8fBvwTRxsryYOTKhIfrcEMeMk6daUPwfkDnt5BvgsV4U3T4NbkK/0ysFHVusSfOxPJnrUSyVszH3+S6nNc5sWKFJl/g37gcOA9GhNjeKkYsk27lrg4aJXboNmz6UdmKEhwd5UfI0GOgyXCEs/Vwx8JHBHQTsBpiuGUQO7E5KDQLoc1MFO5E1wfk x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?V9nBlNF2UU9HXU8TcJ+qO2E1jEEbGDpbkJgSvmaU9mns8VFCfx/SyUJdWkOK?= =?us-ascii?Q?kbXcIEzIFLUgfq+nSLl/9/YtpLO9yMngL4qvgKhdNMAZ/CfW4jh+Fog5uu4v?= =?us-ascii?Q?+zhph0DAeplX3MVuSkKEfbWUJOnAEpzobmM81tCLFz9x68hDG4QG3qB49XcA?= =?us-ascii?Q?5r3VLxB1D8YDHYnhbJeGWgVj3kadsOso0VOjwkNis95mqRm8/5dNEo3T/LYQ?= =?us-ascii?Q?ZpXh/CkLuKicYwkbz63zsuFldmkFK8TSHD19gWpcKIWmnhyOJ1VX2r1zr2JH?= =?us-ascii?Q?hcvez0cwleBeDhPU5yilkKc1nRecbRPaBUqmEyG3IYHWY1YnBCuXRY9UdqV8?= =?us-ascii?Q?ZBc6E8CaMz+WuZdAiqdKiAcJ5Zs/GyznoMmw8d2yc9dz6Sl8k6RTQkMgszk7?= =?us-ascii?Q?mUBcyHt4m73AbcsuG9glTtXSTfJOooTFWqHZlVi9CMRy3PJExY1jYC6HQvhh?= =?us-ascii?Q?G+Zt+3agYfGPQHmDW90jJkQQ+I+oBsauegZMZlnp7irf/nbyBciKfhIg2IGa?= =?us-ascii?Q?asXdSFIwL5Y/e6romQgVMWIm8oXKkXxZBMts3c+YhEOAMS10ks24RxV6RCL/?= =?us-ascii?Q?HCmIJYTiNuzXAvq7RdTe/nJiai9FPy8/CF9QZVVoDO0JH4412PXdnHTCrnZW?= =?us-ascii?Q?UlX8/j9AJLO0mTQv4cjmMzS1aNhBEz36sJN+veFjrBjHIIrakM+K+VdweA6r?= =?us-ascii?Q?BiPWngnGvwcqWr+jYW0ptXGSoEYv2pav5j3c5fDK1X8NIM/3NW118oc3mBgJ?= =?us-ascii?Q?nBtIVbTjKrY32iSFnCYoNWwIrjh1+1oftBX/Fm0w5rvt878hjd6M/L/taMpa?= =?us-ascii?Q?hLjNb6gOd5zObnjVWClCaI8kkeSAbOcTyg1bIR3CsXeHncT+itB4qw5e1kYG?= =?us-ascii?Q?zxVqMGTJ1HcmJzP1hPfVvz24GnAyrFQHSEQpEJekE1mGbG2/niwBc8uctCKR?= =?us-ascii?Q?6ou1pBQujOkwEmTTzuNpveT+MrgVyD9THKYpP1pd/FePZ+wgIyVVfiu8G41H?= =?us-ascii?Q?iys1Itg5hnq/vHMWjhZrf2VCCN7EkdI358hr4VJEWuuV4UW1B9XABNGhvehy?= =?us-ascii?Q?htUfA9mSq5V38WLuoA8XugmKnYGdwqgA6ZjvggbPSnSuZEu5zHQrF3M4hY8X?= =?us-ascii?Q?qD7doS6OmLjH3DqTptpYHe6OSZU3Gr+XDNKF5AhvOH0pKOFqXSufOmsNku7I?= =?us-ascii?Q?Rx6xfUHybVpNRaXrZVPDAh6WL9R5apNWPTgs0ijh0JV++nw2L4sydzzc+A0?= =?us-ascii?Q?=3D?= Content-Type: multipart/alternative; boundary="_000_DM4PR19MB5978BEB92FCD2765A0E6AA9BD35BADM4PR19MB5978namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DM4PR19MB5978.namprd19.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 0ea68699-9bc8-4482-91d9-08db6dc3cb85 X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Jun 2023 17:13:10.3116 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO6PR19MB4754 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DM4PR19MB5978BEB92FCD2765A0E6AA9BD35BADM4PR19MB5978namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable @Tom Lane Thanks for this email. I am checking all the emails. Sincerely, Sarwar ________________________________ From: Tom Lane Sent: Wednesday, June 14, 2023 6:45 PM To: M Sarwar Cc: Scott Ribe ; pgsql-admin@lists.postgresql.= org Subject: Re: The same result for with SPACE and without SPACE M Sarwar writes: > I expect this to behave the same way whether it comes from CHAR or VARCHA= R. You expect incorrectly. CHAR comparison is insensitive to trailing spaces: https://na01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fwww.post= gresql.org%2Fdocs%2Fcurrent%2Fdatatype-character.html&data=3D05%7C01%7C%7C1= 0a23b4db34a484aa3cb08db6d291b28%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%= 7C638223795537107272%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2= luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3DPMlQtWXS2OrzG%= 2FNZlFB3qGpKwKaTjnA4fsEQKFTVivk%3D&reserved=3D0 regards, tom lane --_000_DM4PR19MB5978BEB92FCD2765A0E6AA9BD35BADM4PR19MB5978namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
@Tom Lane
Thanks for this email.
I am checking all the emails.
Sincerely,
Sarwar

From: Tom Lane <tgl@sss.= pgh.pa.us>
Sent: Wednesday, June 14, 2023 6:45 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: Scott Ribe <scott_ribe@elevated-dev.com>; pgsql-admin@list= s.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: The same result for with SPACE and without SPACE
 
M Sarwar <sarwarmd02@outlook.com> writes: > I expect this to behave the same way whether it comes from CHAR or VAR= CHAR.

You expect incorrectly.  CHAR comparison is insensitive to trailing spaces:

https://na01.safelinks.protection.outlook.com/?url=3Dhttps%3A%2F%2Fwww.pos= tgresql.org%2Fdocs%2Fcurrent%2Fdatatype-character.html&data=3D05%7C01%7= C%7C10a23b4db34a484aa3cb08db6d291b28%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1= %7C0%7C638223795537107272%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI= joiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3DPMlQt= WXS2OrzG%2FNZlFB3qGpKwKaTjnA4fsEQKFTVivk%3D&reserved=3D0

            &nb= sp;           regards, to= m lane
--_000_DM4PR19MB5978BEB92FCD2765A0E6AA9BD35BADM4PR19MB5978namp_--