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.96) (envelope-from ) id 1vysgA-000VXk-0O for pgsql-general@arkaria.postgresql.org; Sat, 07 Mar 2026 14:30:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vysf9-008kMX-1p for pgsql-general@arkaria.postgresql.org; Sat, 07 Mar 2026 14:29:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vysf9-008kMO-0p for pgsql-general@lists.postgresql.org; Sat, 07 Mar 2026 14:29:51 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vysf7-000000010cT-3FJ0 for pgsql-general@lists.postgresql.org; Sat, 07 Mar 2026 14:29:50 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-4163a7c7ca5so4446069fac.1 for ; Sat, 07 Mar 2026 06:29:49 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772893789; cv=none; d=google.com; s=arc-20240605; b=ldJcmkKSa4zvVcV5p/0btljm+4GGp8os+8MZ45zob+F9Vxy0ceT+51opuEFYqCD8td WdchQ8t1kgHbwPmdnWrwGyh4h/o6LWhNoi6TeHebtVNiHsWG4CC7v3aH8mbRglUGYKs4 EPlXiGJBR6WTPm1roDGFU9pxqB2aV5kAwcHkA6AvF0qKScyvFSc8g0E+NmaSnrODn31D WxzRBcO28+d0g/X5txeGldtXqWfS1eMNji+mZxowlzny26cEe19Bc7cR2IkmZKxI5GOe 6wAAOFZvAPMVHroDgU/MiCy0+MVb4uFjBV43c+hHm3cH8bGh4G59mZCNRbRrqA59Bc0y vXAQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=khd52oppL7qFDu0H7xLgRCH7ibPuQzd7gW2pbgQWn5g=; fh=MqX3/PjeIRWyveucHIwmT3MEzIvphFWgoM5FEnVDTkI=; b=Iwyc4ALppoOeTSQ6OeGkv36PcgeWDC/gOLqwJEtWsVWD4IjAe0OG1pl31B2qRN8Sxn +hr/bXaLztjYs/N4Rtlx6eDXvEHaTeWGEGMpdze8M86YteN9YgEHZPEGXDCnivv8doBV fOUZwbq5HEMJWnD9UyrM+cZ44/XTG+ooxsENXMzz5FZ54CfeiaEgwHyijS+XJ151Ps+3 as0RxQLT3xrPL57MDYgsJgp8/0/KwvIOBlWTJARh+QiiHgsC1S4gu7BYKL4hCHjiKR4x r0FxnBej7hE5Wk9sgDs5fiZzOlhdebELyhwgD86mD/bKzNYLQsGCe0AKZvqPN0SEIjeC wzdg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772893789; x=1773498589; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=khd52oppL7qFDu0H7xLgRCH7ibPuQzd7gW2pbgQWn5g=; b=l0nCB4tCjCW2wTZsrpzlICQLr3GqrZAFgQjpCmDdPXnuxg2MQjV7saRBfTJvvtEVam 1sL8m/k5iyo8Jc836B1Uq981O6Ivajj5gbMXY1BCXt3Ib2ezS3GDm3LBiBX7WUwDIqxB 1cHsynHy7q2p4goxlKlCcTcO8BSnqgA8luEPagSP9qRjCp0bdXSAl3mgIpWSNX/+Ka6O IxiBBs89UB102a3p4vnGuvwLh5wwmHOyqMu+SBugpgTu5p6YKD9JKK2QvGMC/Ot46kot p4gtebVKAoSZUjouyYV4dws4uwmkRiCb0dMJa9x/sw5TxY5lLvK5hQ7V93wBeyUoPuxk XNDg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772893789; x=1773498589; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=khd52oppL7qFDu0H7xLgRCH7ibPuQzd7gW2pbgQWn5g=; b=hW2vFZuS340KH5mnUhBoP4Oa3T0yM5Tx261ZuVPcLWx6KfxDEIFqAZvhq77yCmcoqf j6TqCaGd42fUnq9Qq+VWVzZyDJ9emVZclCh0tKS7TV+tYXCRuG3lPlw/y79FHuuTzxRE vhZo96kPE8QSQzfJEsy8KglBmkU7waiW2Ql49WAwkbL1SFzIWiACCBDTePSZ53xJvEw3 hInb7hXXswKd+ejFWKjqwZs+hHwaMTngAKQ/PDpfjmUe2HI3bKdRwgx84WusPH5hMaVp xjAWV2wu/SEAllqFwiILOiMeoeAcx5TBaRxMsCkQwTHJbCm6HRuRswsQA4iVdMiRxosQ FdUg== X-Gm-Message-State: AOJu0Yy4PB+VwwUA6rxCiQWz6zPSWo/PLaH2Bs1kjNOMj7h3r1eMi2Gd 7DRfSGe66TUhmXqCKEZBFX0qELdi0OSSZRVy65BYna1VTcEgUKxoa6A+jKcQ2ggBc4Vo8tdOl/H DBeQwXO4adQFzFVN88agUfZuHua7UOiE= X-Gm-Gg: ATEYQzzvX4k00bykMB93qPdoA1UsfOk9o5tJxEmbxrAqbbFUjy7vpbuqtqxh2Xj6tx0 dm55zg++dQupbtHY8qCNt1k/WOBsxa8SFFizpHevJFPjc+6r8iGwI5FlcJOH2Oa+p3fXOlfSJh4 9BDtq78man1/A/+jIxAfYcYIfCKnqAGn1gkRZZXvBKS43dZdf8+7REn/G6VoUEhPzqIiBRpd+XI TlCRVZUiTS8ToVWb/IliFF6KrV7l6VFPymStn/YEd3Z0UEQ5Mm+7NGobl8hOKWapz7QAtj/Mpzb jdu86Es= X-Received: by 2002:a05:6870:1596:b0:409:8564:840b with SMTP id 586e51a60fabf-416e4497aafmr3132485fac.39.1772893789146; Sat, 07 Mar 2026 06:29:49 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:1444:b0:61f:d197:af70 with HTTP; Sat, 7 Mar 2026 06:29:48 -0800 (PST) In-Reply-To: References: From: "David G. Johnston" Date: Sat, 7 Mar 2026 07:29:48 -0700 X-Gm-Features: AaiRm5346iaeI6Yir-eaYSX5FIb6m25kEPjOv_QZq0effhhIh0FG9O7rm5vbvcg Message-ID: Subject: Re: How to properly use TRIM()? To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000086d450064c700001" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000086d450064c700001 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, March 7, 2026, Igor Korot wrote: > ' > name | tablespace | included | storage > --------------+------------+----------+--------- > leagues_pkey | | {} | > (1 row) > > Included is one, storage is not. > That=E2=80=99s a terrible way to determine the data type of a column. Did read the error message you were given? Did you read the documentation? David J. --00000000000086d450064c700001 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Saturday, March 7, 2026, Igor Korot <ikorot01@gmail.com> wrote:
&= #39;
=C2=A0 =C2=A0 =C2=A0name=C2=A0 =C2=A0 =C2=A0| tablespace | included | stora= ge
--------------+------------+----------+---------
=C2=A0leagues_pkey |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | {}=C2=A0 = =C2=A0 =C2=A0 =C2=A0|
(1 row)

Included is one, storage is not.

That=E2=80=99s a terrible way to determine= the data type of a column.

Did read the error mes= sage you were given?=C2=A0 Did you read the documentation?

David J.
=C2=A0
--00000000000086d450064c700001--