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 1q9nBk-0005fX-4y for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jun 2023 13:39:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9nBj-0006wr-0Q for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jun 2023 13:38:59 +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 1q9nBi-0006wh-Gm for pgsql-admin@lists.postgresql.org; Thu, 15 Jun 2023 13:38:58 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q9nBc-002M3u-LV for pgsql-admin@lists.postgresql.org; Thu, 15 Jun 2023 13:38:54 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id A7E98615A4; Thu, 15 Jun 2023 13:38:47 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1686836327; bh=rVtPbXPT3tE2DkI3EGvKvHEbYIcOofGce9pFBlRyoc4=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=Fk8U11wjRoJt6m5faf4A5lY8U9cQOqYtHuS3kNWiiOT4sP+YpNBBarQkTmcnRZ7kz NZN/HfEF3s5X+TZ+M+Hh0rDC30vFiG87xVgt+ttFZfR8ycrqNhtcejrX1VTFbGk1aG 9W/g2PrLHvj7E3GX9padzvrcOaphqb78y4viUtnBNfVCpn5tQowl4AZW+PFIfvcJLa c25unU+2CSk4yjbpPTS+9vIwD7ixu3a7HlCplte0ZTuWc5b5U02xMXQGFMlWyOnSBB ukh1JFWkL0y8/yQyHA6Ra7WFkwzmnKh4waRFSCJvlvNQh+4g1/AXSVYZEe5n42mI6s TpUpg1n3S9NWg== X-Virus-Scanned: Debian amavisd-new at emo07-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo07-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Qp3HI1omX33x; Thu, 15 Jun 2023 13:38:47 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 0495C61436; Thu, 15 Jun 2023 13:38:46 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1686836327; bh=rVtPbXPT3tE2DkI3EGvKvHEbYIcOofGce9pFBlRyoc4=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=Fk8U11wjRoJt6m5faf4A5lY8U9cQOqYtHuS3kNWiiOT4sP+YpNBBarQkTmcnRZ7kz NZN/HfEF3s5X+TZ+M+Hh0rDC30vFiG87xVgt+ttFZfR8ycrqNhtcejrX1VTFbGk1aG 9W/g2PrLHvj7E3GX9padzvrcOaphqb78y4viUtnBNfVCpn5tQowl4AZW+PFIfvcJLa c25unU+2CSk4yjbpPTS+9vIwD7ixu3a7HlCplte0ZTuWc5b5U02xMXQGFMlWyOnSBB ukh1JFWkL0y8/yQyHA6Ra7WFkwzmnKh4waRFSCJvlvNQh+4g1/AXSVYZEe5n42mI6s TpUpg1n3S9NWg== Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.600.7\)) Subject: Re: The same result for with SPACE and without SPACE From: Scott Ribe In-Reply-To: <0055148e2cc742cbbc23485ae0c6c04e@express-scripts.com> Date: Thu, 15 Jun 2023 07:38:36 -0600 Cc: Tom Lane , M Sarwar , "pgsql-admin@lists.postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <2CAFD37D-68FC-4A01-BE65-FAF1ADF7A60A@elevated-dev.com> References: <2018059.1686782739@sss.pgh.pa.us> <0055148e2cc742cbbc23485ae0c6c04e@express-scripts.com> To: "Wetmore, Matthew (CTR)" X-Mailer: Apple Mail (2.3731.600.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jun 15, 2023, at 7:08 AM, Wetmore, Matthew (CTR) = wrote: >=20 > 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.=