Content-Type: multipart/alternative; boundary=Apple-Mail-7605932D-B951-446A-AA0B-EFEBB6F1B4D3
Content-Transfer-Encoding: 7bit
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: How to properly use TRIM()?
Date: Sat, 7 Mar 2026 12:19:52 -0700
Message-Id: <F6C9D4E2-2FC5-43B4-89F3-46C5A0A770B4@gmail.com>
References: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
In-Reply-To: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/F6C9D4E2-2FC5-43B4-89F3-46C5A0A770B4%40gmail.com>
Precedence: bulk


--Apple-Mail-7605932D-B951-446A-AA0B-EFEBB6F1B4D3
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html class=3D"apple-mail-supports-explicit-dark-mode"><head><meta http-equi=
v=3D"content-type" content=3D"text/html; charset=3Dutf-8"></head><body dir=3D=
"auto"><div dir=3D"ltr"></div><div dir=3D"ltr"><br></div><blockquote type=3D=
"cite"><div dir=3D"ltr"><div><div class=3D"gmail_quote gmail_quote_container=
"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex">reloptions text[]</blockquote><div dir=3D"au=
to"><br></div><div dir=3D"auto">Then why it=E2=80=99s not showing {} as in t=
he =E2=80=9Cincluded=E2=80=9D columns?</div><div dir=3D"auto"><br></div><div=
 dir=3D"auto">Or it=E2=80=99s an ARRAY() implementation?</div><div dir=3D"au=
to"><br></div><div dir=3D"auto">Thank you.</div><div dir=3D"auto"><br></div>=
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex" dir=3D"auto"><br></blockquote></div></div></di=
v></blockquote><div><br></div>One is an empty array, the other is null. Thos=
e are not the same thing.&nbsp;<div><br><blockquote type=3D"cite"><div dir=3D=
"ltr"><div><div class=3D"gmail_quote gmail_quote_container"><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex" dir=3D"auto">
<br>
<br>
&gt; Included is one, storage is not.<br>
&gt; <br>
&gt; Thank you.<br>
&gt; <br>
&gt;&gt;<br>
&gt;&gt; Given that error message, an array of text is the correct type.<br>=

&gt;&gt;<br>
&gt;&gt; Array[]::text[]<br>
&gt;&gt;<br>
&gt;&gt; David J.<br>
&gt;&gt;<br>
&gt; <br>
&gt; <br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klaver=
@aklaver.com</a><br>
</blockquote></div></div>
</div></blockquote></div></body></html>=

--Apple-Mail-7605932D-B951-446A-AA0B-EFEBB6F1B4D3--