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 1xOpOk-00000000M06-0vJ4 for pgsql-general@arkaria.postgresql.org; Thu, 05 Nov 2026 04:48:27 +0000 Received: from localhost ([127.0.0.1]:54402 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xOpOi-0000000AAZH-2H4g for pgsql-general@arkaria.postgresql.org; Thu, 05 Nov 2026 04:48:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:58266) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xOpOi-0000000AAZ8-0jG2 for pgsql-general@lists.postgresql.org; Thu, 05 Nov 2026 04:48:24 +0000 Received: from mail-dl1-x122b.google.com ([2607:f8b0:4864:20::122b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xOpOf-00000000Iqn-0fgD for pgsql-general@lists.postgresql.org; Thu, 05 Nov 2026 04:48:23 +0000 Received: by mail-dl1-x122b.google.com with SMTP id a92af1059eb24-1b244fb7fffso2014823c88.1 for ; Wed, 04 Nov 2026 20:48:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20260707; t=1793854101; x=1794458901; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:content-type:from:to:cc:subject:date :message-id:reply-to:content-type; bh=nPSR0DpzoTS8x9v+gsbF80nK6AC3kBlN7GtOEEKirqM=; b=lbFZ3t8dhw6wqcT+XSF5QFrJNV7pmqE9vhTDMO3iVTdqbDVYQeM66qGqk9CfItjBAO 8IAKVrDg91oTJ8m6M4wo3TS5NPSCA+tNGCfKKDCw6fSoqp3TmnQzM3B3ohhj4dFUHjva K/pJwrD8Oq6J2aI581E17N9QxEadsMdyUjW/KVf/wEmvKbfJ61i+ooxUTlTlRpAr6/Hn +eIhJkhW11Wdo3RFPs9sLz/RL6IaVnoFTRhtINeohoQCbJnAxf+mxNR0ZtJMtdcSXEiM KlJThWw2RcjyVvQMdjAl5AHuZM4Ki0bfeaZcPPi7wxuepnU+4Ki1MGTx2OwEklhZPdw7 OyMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1793854101; x=1794458901; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:content-type:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=nPSR0DpzoTS8x9v+gsbF80nK6AC3kBlN7GtOEEKirqM=; b=w+iA3OHshnwWFMNFfGeM3dnDtv6unf+stfLrIPzupbYVaqk2TD0n5P1Uq8+78UkVIk EwNBx0x+W442aA2zVhWduUJ5/MbCKhe2utsPhTkj4HGdXiyUEwEkMo31JiopCz6FLgdT isHeoK14DQzSa79Kf32gfr5+Cwox9E1KNLT4SKGCiA7rvB5S1CEFW0sGzz/GIOhpLIVG MLL0F1Bt0oArqNgaHbMZePbmxfcIv7lV/tnqTzn93vzS/joB4UixxV+ZxwlZz9jhSetz 4chCThkAreZJ5Z1fJyNSh7M2MgH0mC5ylq8/jqYemnaZC6USWLyF5vKwnyrVGpw6eW8M SGzg== X-Forwarded-Encrypted: i=1; AKwUvBxxVdYCb55w1ZujvPKbRYyxKocO4l8wyJtIx9k5ZmqfIKyCamCNjF0fyS33NKix+5KbkSRyR0trv6TbLHg5@lists.postgresql.org X-Gm-Message-State: APuU4Z+TRTHXjP7hCtGhBLiyo9NWJdY1I0Vi5rD64n09XJgUWcQ2gbLz JLt/8tFGJZt55HWNs/Mu8qUb7q7hjen3fm1aiNHhkeeb7Ve4sbiCwQgrSrYwpQ== X-Gm-Gg: AYBFou0eJ+zXcTn3gizUnHHzTHNzNrsWIltTZc60vnOLD2CChOyzvPeM59u4i7adfIj DNAtpkqzeQiqi6TiFFdofg589tC/m/GvNJcKDS21zH3yxCqrcFWc2mDbYemk59nyPoJUO7oppRx wBKJO7uRMqKoG84VnSh580KqVi/fKm2xkUjVCv+5C3b7O2p4by+jiUUFATB9Ue8aoeNXMaMm5Ku zw/TI96I097wK7kPbfeAn2MPd+bhMxNoEKxQsh4QkYWQGlR6DAGrCTDXZx1IFEV5guf/JeXfwQx zT5FQy9lYWoLwcUERkMJ4I+N/+xwFo1xafaujj4lkamj/s3nU0itv+usJ05ALqgAKzhFZDdJOBp VkN5pSXt/w2XUwBaII5K9Pb93XfVKMD7BVacniklcPQjnscylxOkdyXxlMsRdgR6IC9TauxMduz WcmJXd901H7mYv6mbHrxpRbZPFLrLvb2z4cSU0Xdo76FWBvUD5TmmWd4pJdHfs+CaFpwYQyEJPz /PKi7SWdmrsArv7GYZKNBIaQGaTRnxItqPRpGJmC0mOYElwWb4NGje/a9ymFKhsNs8Nhg1ahDub xfbeT0sLuzLZB/BQZ5VFhw/NwC0eQZQhyZ/vt+hEpQ8Wa2QUF4m0uWUw+/01UA== X-Received: by 2002:a05:701b:2094:20b0:187:efba:9ba2 with SMTP id a92af1059eb24-1ac5e8e1decmr28166817c88.44.1793854101141; Wed, 04 Nov 2026 20:48:21 -0800 (PST) Received: from smtpclient.apple ([2601:681:4c00:3ee7:3c3c:f000:7d15:6ea4]) by smtp.gmail.com with ESMTPSA id a92af1059eb24-1b245c4f83fsm18627074c88.17.2026.11.04.20.48.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 04 Nov 2026 20:48:20 -0800 (PST) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Return trimmed string from the query Date: Wed, 4 Nov 2026 21:48:09 -0700 Message-Id: References: Cc: Pavel Stehule , "pgsql-generallists.postgresql.org" In-Reply-To: To: Igor Korot X-Mailer: iPhone Mail (24A446) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Sorry for a late reply. >=20 > So does this mean that if I use varchar instead of char I will not > have this problem? >=20 > Thank you, Yes. If you use text rather char(n) you will not get space-padded values.=20= If you have char(n) fields already you have work to do to irradiate them. It= will be effort well spent though.=20 >=20 >> (1 row) >>=20 >> regards >>=20 >> Pavel >>=20 >>>=20 >>>=20 >>> Thank you. >>>=20 >>>=20 >=20 >=20