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 1q9Z1i-0001pd-GQ for pgsql-admin@arkaria.postgresql.org; Wed, 14 Jun 2023 22:31:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9Z1h-0005ha-BT for pgsql-admin@arkaria.postgresql.org; Wed, 14 Jun 2023 22:31:41 +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 1q9Z1g-0005hR-DF for pgsql-admin@lists.postgresql.org; Wed, 14 Jun 2023 22:31:41 +0000 Received: from mail-mw2nam04olkn2095.outbound.protection.outlook.com ([40.92.46.95] helo=NAM04-MW2-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 1q9Z1d-002Ehc-D9 for pgsql-admin@lists.postgresql.org; Wed, 14 Jun 2023 22:31:38 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=IQTwXKgQygTs50jjGdKm7bjXQfDGS9aEw6Lyl3rXzJngM7Ms9+GlYJ0mDc+dygkp7Hu7fBHwynl1c/CZt2RW2aKGUGo+I0JPHC2fPABSY9Ufr9MyaWdJIwg6QrDIfjzYphuAK/C8zomJnlS/l8tS04gWLdo2pUyYwY6AqV1jxviGeqqQdN8v3pV17DLlk7ViyONDsK9ocWTbd3y0FIPAR42UEUygQBvj0e1N7i/zYkVBx4Ltw0aT9pJq2wrpErI2FXJexVFU6euLl+LTaIzFHUvEjdH8zxys6SyyP0cofvYJspqKJW7xPV23+w3MAkZjCw2VsvadrNhYg1PzMkSzaQ== 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=dHb/k6lF6lxZKZOT9YJvEHukDR+AoEJV4B5pqgXkpZs=; b=IE3RTKvBeTaLdfzmUnN70fiTJuVVRohBobiBpNtRWruO5Wpj3sskUHws9EQkG5E+Oa5Ix8Srrtcz9BOd1e9AkvQSW0gYJ5V+HSKSjiBogscRnxTzzQmZW+XFZUOqWCnLI48DLJ0C+U+aHacfVX/qRP3XQDCzksFXvpvd4sYpqxgJo/HfLUyVRxAz7iK7IdJnOs+WndK0//3dIvNLvJrtIvGy28gi1k+3dS0lg/18BSrtfIi6FbvTLpU45rEQEEyK1LZWf/ZMliW9HCeA6xZuEMbVkzXos7MLgSm/tExSFQFIT4bCnjT99QI5SDoZN4pc2wIkQ80fb2+bTO8qkH1lXQ== 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=dHb/k6lF6lxZKZOT9YJvEHukDR+AoEJV4B5pqgXkpZs=; b=V2VkP/3KBCwv6i2/C9ZZEe7Lp88uh14j8Pt23IcJLtpDZ6zTxyHmoQGvCeuxCI+Fc47TSHXkTCuAu8D1IG+/0otji0dM8QF9b3j2zdFRzaOEf7mw/jOX4a+6EmhPWeEMSu13PciHvcZoC0pslrZDBGhgVvhc0FKEzxe3vcDq6g7eFlcljY0ZwGFIfSr9l1WmqRa0o7ysm+LH1kNWVgBrvqHsxo8IIm0Xhqo/LcbSs3Bj2QVQ+pAh2nqtiWDc5ZHqUrWfgz8YOR3tIDnwtq/vUE0I7jM9APvTrfmzG4+AKx0jvIkp+Z1ztkgH3Y1O9s1y9Y7sdoke7aNMWMX98zM4sg== Received: from DM4PR19MB5978.namprd19.prod.outlook.com (2603:10b6:8:6a::18) by BY3PR19MB4884.namprd19.prod.outlook.com (2603:10b6:a03:367::18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6500.26; Wed, 14 Jun 2023 22:31:34 +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; Wed, 14 Jun 2023 22:31:34 +0000 From: M Sarwar To: 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+K1kAmgAAH8ICAAANa0A== Date: Wed, 14 Jun 2023 22:31:34 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [Wwv33KMg+Vas4djH0M0a2+MQOaDXBE9c] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DM4PR19MB5978:EE_|BY3PR19MB4884:EE_ x-ms-office365-filtering-correlation-id: 358c5a48-e809-486f-febf-08db6d271c13 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 3LcQ/VwfsN8Q7UhaT0ONDY3weuncggjlQMDwEJdbIvbJLHxBaG2XZ2P+RJC0Q/3sob+jNp+kL/IgsnErIH5hJ9H6qZf4kCGoGBZQG8MXOiaHdsj9E+E//6yS0ogo4a/+EkFid6pM1FnZak70pW9Kgtgad1rKWuJJ1GI24/9nY/iRYoFWzSojKxC5FX+xDO2XKXL89Un/LJM9/Jfz0+OCdtC8aVKl0iez/7m8d8p7+8T3SSJ/dbwbYizEu3MvITR/lTRNNslDFrDJXz7HpzP32LuVSwImyPTh+KcwPD7aJ7JBludC4ReBhz+sxT8d01hQYcWAs0ft/jAtJ/+KHpEUDlpA75HCHS2oZBD7fs3iuZscOq8f89xIM0sYl9SQJ9E5sZ+C1tM3R5vI542v9K+ovic8Hu8XXZoNSD9M27eYIZaDRALSnms3qbg4pzzIYh5GeIVgUxDk/08orwjQHM2mc9FtGPVB9YDv8CLUZiUmV8bM2b7p6UzAJ9CDMuR9gJtMXG4WGgtvgZrxUQbjOfhRDRD/L06ttCn15armtkk0iuV0lf8fsrUF2OQoGDf4WTQI3onqNt+UgTnddAThx/R+VFA+KHEDH/hlEcf9g7F9Gs8= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?51oARW7/ZvSb7xEefvarRLAc4uscITvar0pq0hbPUrJyUNIlVW2Ai+W6jzUv?= =?us-ascii?Q?tkxms4+YUeWgSsTE3crfZa2CNsieigt1psvPK1k5r7JKFKpMtjxUEPxxD1e1?= =?us-ascii?Q?UgGkSUtQUuVSlcr80IaNamhzQcOR26LwwxqYTZ/R1edOxBPJZFAy+orlXqJB?= =?us-ascii?Q?oQy23o1jFwxEmRfBHziJr9d5uKkHqLjZ936x1QLvdQXABfqHZ3Drk/vVAf6a?= =?us-ascii?Q?lMBRbdm5QwZj3EIc7bsHt8R4e9c/LsmSpYQING4864dHifxJAEBPqc8/JdQZ?= =?us-ascii?Q?4U2mdyDM0Fn7DGCLqSqRNSzuFwrQopebePBG7CduQ7k0un3Ql3/1XjrYHuG0?= =?us-ascii?Q?lF4zYG0Q6lzsRHX3V6T+lAR1hsS33iGfafGQIC/9d+EJd1P3hu/EEuBhuuWq?= =?us-ascii?Q?si3ojiLuCq3Q7zNIh+vwWKmOHFAKFXViXvQQra5mZGC0RagaB7v+T7crAH14?= =?us-ascii?Q?msNk+XQQmsxI1vRqjjN9AEtGJEy9dMCvSVLtbfIw0GBDYA8FX5L5ZOUbZ3ee?= =?us-ascii?Q?m0EH3qocg4kA/peIwyw/9L7oGumpH3qfyXPaZFaWNhmROLckmjIZ14S0HMTC?= =?us-ascii?Q?piJrGBwmRP6dGMZqLLuhAnRvYcIlPOXG9kM4K/panmgjuwvx66tSpZNE7Z3v?= =?us-ascii?Q?yJN7ChSVsfwmHMfypcwhtoFG/3v4XTas4HlEBdhoHqcG/mwhKpwv2rYmuhtS?= =?us-ascii?Q?AlNT4jwwJVMSfq8sCFicaZAhpj9tWp7WF5R07ltYNF94jWZj/oKKqKVt8LTg?= =?us-ascii?Q?PwahKzn+AvYe60kyfGgAOMf9hwFLedcgAgX9asADQH+s3AIsJ+wvxkNK4IFE?= =?us-ascii?Q?GluXBry6JLwIIyoctxqcHCxkDjsxAp2A3S/E16Py8957M+k4NlUNskqHZ0Vr?= =?us-ascii?Q?MvSIrnaKgjXH3GTyHj5Rlx3KpiJQJWT+fATFnL6A6HR9GG7PvN6AN833yqtE?= =?us-ascii?Q?EX7HyVZjjPR1arTZBknAH/4+613MxO5n7BTUZyAiD5Axa1uvA5GwhtGbfDUa?= =?us-ascii?Q?moT8SZcSdDSFMKzY+QVAsL/H3WtWyTpiuyFAVV1M4DqbuwObiy6Fojt3+fno?= =?us-ascii?Q?dVdc4tcqkpnfpRKen6yp7/mOd3X65peW6WZeYqVGC2N4G1H7zynxKPndKb5R?= =?us-ascii?Q?abaiO2Hig4ASShVbSgbwS0++W0v91fSr5SKbvDp8XpBEwWa5qFVIh6h/OGJD?= =?us-ascii?Q?oQE5ZOkLO3atavQahO/H4IDTfp6TFgUZZTCyog=3D=3D?= Content-Type: multipart/alternative; boundary="_000_DM4PR19MB59784B518F25D2C2292CA3FBD35AADM4PR19MB5978namp_" 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: 358c5a48-e809-486f-febf-08db6d271c13 X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Jun 2023 22:31:34.5204 (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: BY3PR19MB4884 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DM4PR19MB59784B518F25D2C2292CA3FBD35AADM4PR19MB5978namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Scott, This is coming from CHAR(10). test_number character(10) COLLATE pg_catalog."default", I expect this to behave the same way whether it comes from CHAR or VARCHAR. Does that matter? Thanks, Sarwar ________________________________ From: Scott Ribe Sent: Wednesday, June 14, 2023 6:18 PM To: M Sarwar Cc: pgsql-admin@lists.postgresql.org Subject: Re: The same result for with SPACE and without SPACE Did you use type char instead of varchar? --_000_DM4PR19MB59784B518F25D2C2292CA3FBD35AADM4PR19MB5978namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Scott,

This is coming from CHAR(10).

test_number character(10) COLLATE pg_catalog."default",

I expect this to behave the same way whether it comes from CHAR or VARCHAR.=
Does that matter?
Thanks,
Sarwar

From: Scott Ribe <scott_= ribe@elevated-dev.com>
Sent: Wednesday, June 14, 2023 6:18 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresq= l.org>
Subject: Re: The same result for with SPACE and without SPACE
 
Did you use type char instead of varchar?


--_000_DM4PR19MB59784B518F25D2C2292CA3FBD35AADM4PR19MB5978namp_--