Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xNXoK-00000002cDz-3StZ for pgsql-general@arkaria.postgresql.org; Sun, 01 Nov 2026 15:49:33 +0000 Received: from localhost ([127.0.0.1]:57438 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xNXoK-0000000H63o-1BDW for pgsql-general@arkaria.postgresql.org; Sun, 01 Nov 2026 15:49:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:37122) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xNXoJ-0000000H63f-0h0E for pgsql-general@lists.postgresql.org; Sun, 01 Nov 2026 15:49:31 +0000 Received: from fout-b3-smtp.messagingengine.com ([202.12.124.146]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xNXoH-000000021Pn-0qek for pgsql-general@postgresql.org; Sun, 01 Nov 2026 15:49:30 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id 177811D00099 for ; Sun, 1 Nov 2026 10:49:28 -0500 (EST) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Sun, 01 Nov 2026 10:49:28 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1793548167; x=1793634567; bh=qfZe0+tgk8zDB1PMOcre84LvDrAFRaaTc8Y7Xq9wicE=; b= UvXI/2UZuBZ4usEyu9VQbBkRLWTe0PZjJv32UIeoxyjE4m1cQTtqL5gr0q1HuC6B pxsOJPd9AmdGz1VI4WxTvVL9pGNIC2JXi3e06D1oXct6htVO3hjEF/ct0ZMInSxD Pi3tL4uwkBpDHCKq6WZEkH+JeE+wZTS+RTiKYTGTUe48PdFUZnJ4L4uSOjylvRJO cngv7XBsLgdHkhVQ10QbZZnpKrJJQdl3ih68lnitfAGzFZgiLfh0ABZIUjIgZ3jN XqFNijgPJHSi5i0HgcaL4Bf51u1MCALbWfO1sYZ8NkN9tdAwxypycMYquS6uqWPf y3Euw5JmmBsHHAKbnp1KTA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1793548167; x=1793634567; bh=q fZe0+tgk8zDB1PMOcre84LvDrAFRaaTc8Y7Xq9wicE=; b=KkrM9lqE17KM8g6DP vnP+Fi9fgsc6HerD+NOFJbLVoORJXCuL22fsFTGAoQ0RTmhQRFrKvnYpNlhjkmlC MEmWYMNEdiERFyVb1G0uaAVWHE3+fvw8oYc74rVpJqPg9S+JohJZn7RIOMCzEVlU 5YeiIfjRprOBzLrYcIltk/4AqRk8MUJ0XGSv1u6j6gY+ukLzWRssa5UsJrySm4eO RTeGhVObS39a3tvzg32BDQzawWauDOkDlffUfOLd1yxAK2tNrBwXvEcLjnlAF8CV mf7QXFFc+PWoNeS6lkLD3AavLul6XutYobmILbxptRa/EXCLZMaVNwLBO4HyDEbm lA5iw== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-08; repo=github.com/dkim2wg/interop; date=2026-10-28; sw=lmtpprox; action=sign d=aklaver.com a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1793548167; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAcG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:dCU3snFe82LTvjjxNSr/4IuxAb0Wb+JVD9aICu+VfubXX6h 9RZ6EXB+yekHM5/65wgl0MCAuVRKl/bBQvnKYw8bzOrNjB2Txt0Rci8rrmILQ5rA tQKvxv9G33KsOm84S+LhfZuJTneZ+7Hsh3P1DuD1fAhAts2tUFFcadZukd0nkc98 J9fecNPIgwd2bc1E8wzuvJGjSQDn7kFn0G4uWFpKwb7O5XUzh8vz32A7WiKm5Umn KdUNLKqq3Nh77Clvnz5+BH0VKL5xVqfvrXki7t02gr178PT5L6L9IspOam7ptGvI sVTk7z/a+CnoqDyw8nHXsWBTZUG7CNcWRPEBeug==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-08; repo=github.com/dkim2wg/interop; date=2026-10-28; sw=lmtpprox; action=mi-m=1; hc=13; hn=content-language,content-transfer-encoding,content-type,date, feedback-id,from,in-reply-to,message-id,mime-version,references, subject,to,user-agent; Message-Instance: m=1; h=sha256:ROVhCnNHUHH9ItC7yFmU9qozP6+YSSn3AblbawxtDhs=:8/zWR5nLlmw5bUaJhg1m3ByajdFJ8lIo66kwR2dK+Ng=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTE1RIfLgqOAS/FOcigdiXPPGgLPUi7Kn8ZnGf0GGPK35asYuWCk14s0Zpn5P4RMbU OvQR0lr6WtGyTtONTLXGgNvm80GjAs8nhko3UXW8Y0JblZdpgTy9UgVHIsWrNiDBc6elaU KXZw5ZJacqoCp1ssoxC+M8IcQthi1/aTWxMKY2JukXmO5t1esN1a2XWuK+P3TGQr3PJ5Ac qaDAViEkwyoci0UFpUwqQghNjZG206D5QAijpVmdL7izqZkA2fdwymr3S/1ZstaeOhzmG/ 17fMlK1v8ug5Ru5lelpd70sBu1umYtjZOJYxJVe2ydmDf25G6C84UeT0RUoQlTQgtyIYHf CGAsiagBguXyYRfhD+GVLnd5gSjjCc84gSLkBDeaZLmXzL5YRIWwJV8rZsLa97k8x6CwCT 8Fap0lWyZwlnvIWjHs4PrrNWkuor081s3+ct+XWl1WmDvEA/ieNHkBdt6jqFhKhOqow4+j p1F5i40XeXxW2rAEfq81PkHzuVFuQB54dQouTOH2u/fPU/1swNvMM9r5sZ4pEdh3u7fShL mekMcGNZeHHho8H80nuo9nMvNB7rCIO4HMdZzhA4zzzBN5CJH+PutaU1emT2NUcsbUjoTp 8ihdj7MOilwYBqNdD759hsHU9qywZCYahogcbtzYHyeLSS9TxaP0glA/lOMg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 1 Nov 2026 10:49:27 -0500 (EST) Message-ID: <36bf0a2d-368f-4c98-bf93-531cb6f868bb@aklaver.com> Date: Sun, 1 Nov 2026 07:49:26 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Return trimmed string from the query To: Ron Johnson , pgsql-general References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/1/26 7:13 AM, Ron Johnson wrote: > On Sun, Nov 1, 2026 at 1:43 AM Igor Korot > wrote: > > hi, ALL, > Is there an option to return a trimmed string from the query? > > If I try to retrieve the char(10) from the table and the field only have > "abc", how to prevent the value to be returned as "abc     "? > > > > TRIM() is the portable/standards method: > SELECT TRIM(TRAILING ' ' FROM a) FROM foo; *TRIM removes spaces by default so the ' ' is not necessary((length thrown in to prove trim): select trim(TRAILING 'abc '), length(trim(TRAILING'abc ')); rtrim | length -------+-------- abc | 3 Even shorter would be:: select rtrim('abc '), length(rtrim('abc ')); rtrim | length -------+-------- abc | 3 > > There are many useful string functions: > https://www.postgresql.org/docs/17/functions-string.html www.postgresql.org/docs/17/functions-string.html> > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! -- Adrian Klaver adrian.klaver@aklaver.com